1 min readfrom 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

submitted by /u/ManWithTheHex00
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article