How to House, 123 Street, Somewhere, M1 23X

  • Thread starter Thread starter Nick C
  • Start date Start date
N

Nick C

I would like the Adress to appear in four seperate columns. Any ideas?

Thanks,

Nick
 
If the data already exists click DATA on the menu and select TEXT TO COLUMNS.

If it doesn't exist, just type it into 4 columns, but preformat the zip code
column as text so you don't lose any leading zeroes should you have zips in
CT or PA.
 
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

reversing text within cells 1
Another Parsing address question 8
Help using Transpose 1
excel formula 2
Sorting Street Addresses by Street Name 4
split string based on a SET of words 8
Sorting characters, ignoring numbers 7
How do I compare the stored data in micro 3

Back
Top