Text Data to Excel column data

[AV114]

I have data in text format and need to convert to Excel column data

Can you please help me

 

[AlanSidman]

This can be accomplished using Power Query/Get and Transform so long as you are running XL 2010 or later.

Here is a link to a tutorial that will get you started.

https://www.howtoexcel.org/power-query/the-complete-guide-to-power-query/