Hi I'm new here so sorry if this has been answered somewhere but a lot of the time I'm finding the answer to the first part of my question and nothing more specific.
Basically I've got a lot of data in a spread sheet that has been copied from PDF so there are lots of line breaks/ back carriages.
To remove these I simply used find: ALT+0010 (line break code)
Replace: ' ' - (a space).
The only problem is, its applied it to bullet point as well, for example:
What I currently have in one typical cell (notice the sentence has random line breaks) ;
Sentence blah blah blah
blah blah look
at the following:
•bullet point 1
•bp 2
•bp 3
•bp4
What I need:
Sentence blah blah blah blah blah look at the following:
•bullet point 1
•bp 2
•bp 3
•bp4
What my current code/formula is doing/ resulting in:
Sentence blah blah blah blah blah look at the following: •bullet point 1 •bp 2 •bp 3 •bp4
Any help is appreciated.
Thanks.
Bookmarks