Split Data

[Simon Jelinek]

Hi

I have data imported from a text file when the data is
copied to excel each records data is in the Column A.

E.g
A
1[12345, ,smith,daniel, , 12, simonds street]
2[12346, ,west,fred, , 67b, sutton street]

I need to split the cells
A B c d e f
1[12345][smith][daniel][][ 12] [simonds street]
2[12346][west] [fred] [][ 67b][sutton street]

Is this at all possible.

Thanks

Simon

 

[Frank Kabel]

Hi
have a look at 'Data - Text to columns' and use the coma
as separator

 

[simon jelinek]

Thankyou for your help

Regards

Simon