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
|