| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
UN - CONCATENATE address
Hi,
I have full address in once cell and I was just wondering if there any way to un-concatenate it in all different cells. Here is the example Cell A1 16545 Dingo St suite 656 Chicago, IL 54545 Please help me if you know how to save all of that cell into 5 different cells (address1, address2, city, state, address). Thank you so much in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i convert an email address to a web address | Excel Worksheet Functions | |||
| Hyperlink Address and SubAddress not concatenating correctly | Excel Discussion (Misc queries) | |||
| Formular to add to a IP address | Excel Discussion (Misc queries) | |||
| MIN Function w/ variable address reference | Excel Worksheet Functions | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
Linear Mode
