Ctrl + H, put cursor in the find box and hold down alt while typing 010 on
the numpad, I assume you want to replace it with a space so put one in the
replace with box (or leave it empty to replace it with nothing) and select
replace all and click OK or press enter



--
Regards,

Peo Sjoblom



"prizm" wrote in message
...
How can we identify and remove manual line breaks in a cell. These are
breaks created by using ALT + Enter. Our client gives us a file that has
these breaks in the street address and we need to remove them. Please
advise.
Thanks