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


--

"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.