Excel Tips: Replacing Line Breaks in A Single Cell with Commas and Separating into Columns

[@Flax.112]

Thanks a lot for your help!! ❤️❤️❤️

[@jaimeborjas]

Great tip! Thanks!

[@jyotikrishnamohan7493]

Thanks a lot!!! Really helpful!

[@kinahhalim8482]

Hi,
is it possible for me to list down the data downward in a same row and not by using " - "
Example
NO :
Book - Pencil - Eraser - Case
YES :
Book
Pencil
Eraser
Case

[@Ari-zp4dd]

Thats helpful!
Do you know how can i seperate semi colon " ; " to line break in mac? most videos show how to use "replace" function, but that doesnt work in mac.
thank you

[@intelligentbusinessservice7913]

You're welcome. Follow the second step in my video, "Text to Columns", but select semicolon instead of comma.

[@charliepearson582]

Columns!!! Who knew??