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.

To replace the dollar amounts with a blank space without leaving an extra space in the sentence, you can use the following steps:

1. Select the range of cells or the column where you want to perform the find and replace operation.
2. Press Ctrl + H on your keyboard to open the Find and Replace dialog box.
3. In the Find what field, enter
   Code:

   $*

   (including the dollar sign and the asterisk). This will find any text that starts with a dollar sign and has any number of characters after it.
4. Leave the Replace with field blank.
5. Click on the Options button to expand the options.
6. Make sure that the Match entire cell contents checkbox is unchecked.
7. Click on the Replace All button.

This will replace all instances of dollar amounts in the selected range with a blank space, without leaving any extra spaces in the sentence.

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.

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.

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

On Oct 11, 11:25 pm, Studebaker
wrote:
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.