Separate address column to Five columns

H

harpscardiff

I’ve been given a spreadsheet to work on, look to be an export from
database. It has addresses of companies; 3 columns in total: Compan
Name, Company Address and Company Telephone.

Unfortunately I need to separate the Company Address Field to Fiv
columns:

Address 1, Address 2, Address 3, Address 4 and Address 5.

Is there a quick way of doing this or a magic formula??? :confused:

Thank
 
Top