separate data from one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I separate the address field like...

[Room 825, Star House, 3 Selisbury Road, Tsimshatsui, Kowloon] all this type
in one cell, and I want to divided them into 4 parts...

1. Room 825, Star House
2. 3 Selisbury Road
3. Tsimshatsui
4. Kowloon
 
Provided the address is always separated by a comma, just use the
Data\Text to Columns feature in Excel, selecting a delimited souce with
comma as the delimiter
 
HI

MallyCat is right using Excel to split the data in the sheet is best, but if
you need to use VBA checkout the split function which splits text into a zero
based array which you can then work with.

Regards
 

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

Pivot Table Columns 2
VBA Conditional Formatting .IconSets plus one other icon/symbol 14
Need macro that transforms key words into predefined numbers 2
Extracting numbers from text string 10
Extracting House Numbers from Street Addresses 4
import from text file with VBA code 5
Multiple rows into one cell 8
Sorting data bust ignoring numbers 3

Back
Top