Forum Discussion
Using Find & Replace to insert line breaks (CTRL+J) erases cell contents
Hi, First of all thank you for reading my post, I am kind of desperate right now LOL. I had to paste English text from Excel into Word in order to translate it. The Excel text is really long an...
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).