2021-04-30

Control+J equivalent using Text to Columns functionality

I'm trying to split a cell with multiple rows of data into into individual cells. Using the Text to Columns functionality.

Text: https://www.howtoexcel.org/tips-and-tricks/how-to-separate-data-in-a-cell-based-on-line-breaks/

Video: https://trumpexcel.com/split-multiple-lines/

I found this video where he uses the Text to Columns functionality but in the video at the bottom of the page it shows him entering "control+j" for the other character. However, on macOS It doesn't work. What is the equivalent of this on the macOS?

thanks.



from Recent Questions - Stack Overflow https://ift.tt/2QI3BHp
https://ift.tt/eA8V8J

No comments:

Post a Comment