View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Find and Replace - Replace with Blank Space

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


"Studebaker" wrote in message
...
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.