Hi there, I'm working in Excel 2003. I need to remove some but not all line breaks in a cell. I have the following data in one cell:
T3S R25W
SEC 3 NENE
FROM THE SURFACE TO THE
BASE OF THE FT MORGAN SANDS
Using Find and Replace the data comes out:
T3S R25W SEC 3 NENE FROM THE SURFACE TO THE BASE OF THE FT MORGAN SANDS
The results I wish to have are:
T3S R25W
SEC 3 NENE
FROM THE SURFACE TO THE BASE OF THE FT MORGAN SANDS
So my question is can I remove certain page breaks in a cell?
Thanks!
Bookmarks