•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Making a table out of many cells in one line
Hello,
This is my first post and as English is not my first language I couldn't utilise the search bar. Sorry if this ever came up before.
I have cells in one line that I need to convert into a table of sorts. In the example after every space follows a new cell.
I also have the same data as just one text chain.
Example: A 1 2 3 B 3 3 1 C 4 1 2 D 3 2 1
Should become
A 1 2 3
B 3 3 1
C 4 1 2
D 3 2 1
[link] [comments]
Want to read more?
Check out the full article on the original site