Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Strip Leading Characters (Office Xp)

    Please forgive me for posting this again but I have lost some backup data.

    I need to strip some leading characters from a code ie N1025687986 I need to strip out just N.

    Sorry and thanks

    Promise I wil secure it this time.

    <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
    If you are a fool at forty, you will always be a fool

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Strip Leading Characters (Office Xp)

    If that is in cell A1, then the following formula in another cell will strip off the first character:

    <pre>=RIGHT(A1,LEN(A1)-1)
    </pre>


    If you want to replace a column of such strings with the first character stripped off, then insert the formula in an empty column and fill it down as far as the strings go. Then select the cells containing the formula and select Copy from the Edit menu. Then select the cell containing the first of the original strings and select Paste Special from the Edit menu. In the dialog box, click on Values in the Paste section, then click on OK. This should replace the original strings with the strings without the first character. You can now delete the column with the formula.
    Legare Coleman

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Strip Leading Characters (Office Xp)

    Hi Legare

    Thank you very much for that it will save me hours of work.

    Thanks
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •