Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Separating text
Hi,
I have a worksheet full of text such as: 1 The High Street, Anytown, Anywhere, ZIP There may be three, four or five elements to the address which are all separated by commas. I would like to separate these into individual elements (so I can import them to Access). I have the functions to strip out the first and last component but I'm really struggling with the otheres. Any help gratefully accepted. PDJ -- If nothing changes, everything stays the same |
#2
|
|||
|
|||
One way:
Select the column. Choose Data/Text to Column. Select the Delimited radio button and choose next. Check the comma checkbox. Click Finish. In article , PDJ wrote: Hi, I have a worksheet full of text such as: 1 The High Street, Anytown, Anywhere, ZIP There may be three, four or five elements to the address which are all separated by commas. I would like to separate these into individual elements (so I can import them to Access). I have the functions to strip out the first and last component but I'm really struggling with the otheres. Any help gratefully accepted. PDJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How do I rotate a text box | Charts and Charting in Excel | |||
Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
how to hyperlink text to a cell | New Users to Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |