Splitting Excel Columns

[Slappy]

Just received the data set for a bus card order of 100 or so people. Plan was to Data Merge the fields into the InDesign doc but not when it's set up like this.



*sigh*

Is there any magical way to split out that Contact Info into 3 separate fields for Office, Mobile & email? And I guess the same for the address & website? Gonna be a shitload of copy-pasting going on otherwise. 

[t-pat]

I don't know how to do it in excel. The person that supplied that should be kicked squarely in the junks. 

[t-pat]

I know there are formulas to do it, however it may be a matter of making it a csv, opening in a text editor like emeditor and find and replace the return character (usually /n or /r) with a comma, thereby adding a column in csv speak