Separate address column to Five columns

  • Thread starter Thread starter harpscardiff
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel help separating / 2
Spacing in Column headers 1
Text to Columns help with my data 1
Mailing address block: sorting 1 row to columns 1
Help!! using sheet 1 information to change information on sheet 2 2
Extracting Address data from single cells 2
Separating names & addresses in a spreadsheet 1
How to separate names and addresses in a spreadsheet 1

Back
Top