Remove Manual Line Breaks in Cell
Try this:
Select the range of cells to be altered
From the Excel main menu:
<edit<replace
Find what: [Ctrl]+J
Replace with: (leave this blank)
Click the [Replace all] button
That should remove all of the line breaks.
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"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
|