Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find/Replace (XL97;SR2)

    I would like to find/replace the CHAR(9) with nothing (remove it) from a line of text. I would have displayed the line of text but you wouldn't see the CHAR(9) it is however included in the attached file.

    My line of text has the CHAR(9) appearing numerous time in the text line.

    Any assistance would truly be appreciated.
    John
    Attached Files Attached Files

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

    Re: Find/Replace (XL97;SR2)

    Enter the following formula in cell C5:

    =SUBSTITUTE(B5,CHAR(9),"")

    Copy down as far as necessary. If you want to get rid of the original data, you can copy the cells in column C and use Edit/Paste Special..., Values option to replace the formulas by their results.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find/Replace (XL97;SR2)

    Hans,

    Thanks for the quick reply. I never even considered the SUBSTITUE method.

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

Posting Permissions

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