| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
text from one column into multiple columns
Hi,
How can I take text entered like this: Mike Smith Toyota 123 Main St Anytown, TX 12345 phone 713 222 1212 fax 713 222 2121 ....and move it to where every address element (name, street, city, etc.) is in its own column? Text to Columns obviously won't work, and I've had no luck trying to make a macro to do it. Thanks, Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) | |||
| Is there a way I can enter a letter to proceed text a column of ce | Excel Discussion (Misc queries) | |||
| How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) | |||
| splitting text to multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
