Nottingham Fox
Moderator
Dear Excel experts .....
I would like to know if something is possible.
I have a spreadsheet which contains approx 316 addresses. It's made up of 5 columns (Region, Store No, Surname, First Name & Address). The address column contains the whole address like this: 129 Unthank Road, Norwich, Norfolk, NR2 2PE
In order for me to import the spreadsheet in to a piece of software the address needs to be in separate fields. I.e Column 1: 129 Unthank Road / Column 2: Norwich / Column 3: Norfolk / Column 4: NR2 2PE
Is there a formula I can tell excel to use which will help achieve what I am trying to do?
Cheers
I would like to know if something is possible.
I have a spreadsheet which contains approx 316 addresses. It's made up of 5 columns (Region, Store No, Surname, First Name & Address). The address column contains the whole address like this: 129 Unthank Road, Norwich, Norfolk, NR2 2PE
In order for me to import the spreadsheet in to a piece of software the address needs to be in separate fields. I.e Column 1: 129 Unthank Road / Column 2: Norwich / Column 3: Norfolk / Column 4: NR2 2PE
Is there a formula I can tell excel to use which will help achieve what I am trying to do?
Cheers