Loading and Splitting Data from Excel

[hopkinsc]

Hi,

i was wondering if it was possible to load in the attached data (Excel) and split the combined columns into seperate fields?

Company Name and Address	Contact
company A	Tel: 123456789
Company House	Fax: 123456789
Company street	email: Company@Company.com
Company City	www.company.com
Compnay Country
Post Code

So i would want the Company Name and Address split into their own fields

Company Name

Address Line 1

Address Line 2

Address Line 3 etc

and then the same with the contact column.

Any suggestions will be appreciated.

Thanks

[hopkinsc]

Thanks, thats exactly what i was trying to do! thanks for your help!