Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    getting rid of characters in a cell (xp & 2003)

    I am attaching a worksheet which has cells which contain "invoice: " before the actual invoice #. is there a way to delete the "invoice: " so only the actual invoice id remains.

    thanks

    Martin
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: getting rid of characters in a cell (xp & 2003)

    Press Control+H to open up the Find and Replace Dialog.
    In the "Find What:" box enter "Invoice: "
    (Do not enter the quotes, but make sure you include a space after Invoice
    Leave the "Replace With: box blank, then click on "Replace All"

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: getting rid of characters in a cell (xp & 2003)

    another option would be using this formula, if the text you want to remove is always " invoice: " in Col E, put this formula in cell E2 =RIGHT(E2, LEN(E2)-8)
    and fill down to the last cell.
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: getting rid of characters in a cell (xp & 2003)

    Don't you mean that the formula should be placed in F2 instead of E2? If you put it in E2, you create a circular reference, since it refers to E2.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: getting rid of characters in a cell (xp & 2003)

    Oops, I meant the formula should be in F2 and fill down. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    Hans, thank for pointing out.
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

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