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...
I have just wasted more of my life on this than I care to contemplate, but in hopes of helping some other poor soul: CTRL-J does not work in Microsoft365 (web/online) Excel (it opens Download tab or window). CTRL-Shift-J does not work either (opens DevTool Console window). You have to go to Editing/Open in Desktop App. Then CTRL-J works.
Blooping heck, I hate Microsoft and its insistence on moving its own products into environs where they then no longer function. (See also: what a Word doc looks like in M365 vs Desktop.)
Blooping heck, I hate Microsoft and its insistence on moving its own products into environs where they then no longer function. (See also: what a Word doc looks like in M365 vs Desktop.)
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.
