Related Posts
Anyone up for chat😔😔 Feeling low...
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
Everyone: Excel is a smart app
Excel:

Anyone have a good source to learn sql
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.







Yep. Find and replace your semicolons with a carriage return/new line character
Thanks so much! I tried using find-replace and tried putting the replace value as alt-enter, [alt-enter], (alt-enter) , and alt+ enter variants, but none of these work. How'd you recommend applying alt-enter to a whole column?
https://stackoverflow.com/questions/34359664/what-is-the-character-code-for-new-line-break-in-excel
Might want to see if this works - potentially find/replace the “;”s with the newline character. Might not work given this is google sheets
Paste data in Notepad++ and copy-paste from there to excel
I would concatenate and do a hard enter (alt + enter)
Alt + Enter is what you’re looking for
In google sheets' find & replace, you can copy a line break character to your clipboard and paste that in to the replace field.
You can type one in a cell with the alt+enter and copy that, or copy any old line break that's lying around, like the one after the sentence above!