View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Replacing text in a cell with blanks

Hi again Tom,

The following might be a better answer because it will also take the line
feed out before the phone number.

In the Find what field enter the following
???-???-????
Click in the field before the the first question mark.
Hold the Alt key down and using the numeric key pad key in 0010.
The question marks will look like they have gone and replaced with a
flashing dot. Don't worry, the question marks are on the next line and not
visible.
Leave the Replace field blank.
Replace all.

NOTE: You must use the Numeric key pad with the Alt key. Using the numerics
above the alpha characters do not work.

--
Regards,

OssieMac