Check out ASAP Utilities, a free add-in available at www.asap-utilities.com.
It has a feature that allows selective deletion of characters.....should do
what you want.

Vaya con Dios,
Chuck, CABGx3



"prizm" wrote:

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