Separate data at commas

[elmaco12]

Hi,

I've imported a large document to excel. It contains 118 rows of information. My problem is that all the information is in column A. Every cell contains long sentences with information. The information is divided by a comma-sign (,). What i want to do is to seperate the information by columns instead of a commasign. So for example:

...A....................................................B....C.....D
1 Div,Date,HomeTeam,AwayTeam,FTHG
Becomes:

......A....B ........C.............D..........E
1 Div Date HomeTeam AwayTeam FTHG


Is there any smart way to do this??



Thanks for your help guys.

Best regards,

Marcus

[zbor]

Select data -> Text to columns -> Delimited - Check , in box -> Finish

[elmaco12]

Thanks alot!! Quick and spot on! Super answer!

[zbor]

Glöm inte göra tråd som löst