Find and Replace - Replace with Blank Space

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I also want to find a $ amount in a sentence and replace it with a blank so
the sentence looks like the $ amount was never there.

I can replace with a blank space OK but it leaves one extra space in the
sentence and I have too many to do to have to delete the single space in the
sentences.

Ex: "800 mi. $200 from Starting Pt. to Destination and Back."

I want to find the dollar amounts using $??? and replace with a blank so
that the sentence looks like:

"800 mi. from Starting Pt. to Destination and Back." with the proper spacing.

Can you help with this, as well?

Thank you.
 
Using a helper column, you could use the following:

LEFT(I28,FIND("$",I28)-1)&RIGHT(I28,LEN(I28)-FIND(" ",I28,FIND("$",I28)))

I28 represents the cell that your sentence is in.

HTH,
Paul
 
Just leave the Replace with box empty when you do your global replace.

Use $* rather than $??? if there could be a variable number of digits after
the dollar sign.

Regards

Trevor
 
In your Replace With box, just leave it empty (or click in there and
delete any spaces that might have been remembered from the last time
you used it).

If you have already done some of these, you could look for double
spaces and replace with single spaces.

Hope this helps.

Pete
 
Back
Top