Separating Data in 1 Column to Multiple Columns

[carrieebacon]

I will be importing csv files where all of the data is in 1 column. For example, cell A6 is:

p0;\H1.25x;\L\C4;CI #15}\PTYPE C\PFR: 19.00\PINV. IN: 3.00 (N)\PINV. IN: 9.00 (E)\PINV. OUT: 3.00 (S)

I need it to be separated (preferably with a macro). Thankfully, the data is separated by backslashes, so hopefully that somehow makes the process easier.
So I would need p0; in cell A6, H1.25x; in cell B6, and so on. Any help is appreciated!! Thank you!!

 

[dreid1011]

Can you not use the Text to Columns tool on the Data ribbon under Data Tools? Or is there a large number of sheets to process?

 

[carrieebacon]

Can you not use the Text to Columns tool on the Data ribbon under Data Tools? Or is there a large number of sheets to process?

I did not know about this, it worked! Thank you!

 

[dreid1011]

I did not know about this, it worked! Thank you!

You're welcome, and happy to help.