Forum Discussion
Using Find & Replace to insert line breaks (CTRL+J) erases cell contents
volunteersfpl The ASCII for the hard return I think is ALT 010
bbkNR thanks! That worked.
All,
In the standard Excel Find/Replace I was able to add line breaks after each semicolon using
find ";"
replace ";<Alt+010>"
Don't type <Alt+010> literally, but hold down the Alt key when you type 010 on your number pad, then let go of Alt. You won't see anything added to the Replace with box, but it's there. Run the replace and you will see the linebreaks in your cell(s).
Typing it in or using it, neither works for me
My text is
"
BCSC"...so first line is nothing, just a line break.
Nothing I try when using this to replace that weird line (artifact of the software that produces the report).
I finally had to just copy it from Excel, paste it as plain text in word, which changes the line break to "P (pretend that's a ^p)
Then I used find "^p^p and replace with ^p.
Then copied and pasted back to excel.
TraceyLeePartridge
Here's the Wikipedia page on how to use Alt sequences to get characters not available on your keyboard.
Alt code - Wikipedia
