| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Address fields in columns...
Hi - one day i'll be able to help but alas my excel quest leads me to learn rather than coach until that time comes, i need your help.
i have 10,000 names and address in a .txt form which i need to import into excel, save as a .csv. The names are formatted as below: Name : fred blogs address: 1 the street addres 2: address 3: Derby plus the usual fac line etc... (10000 times in column a1:b1) how am i able to have the data under one heading and 10000 rows....? your help would make me very happy!! nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Address fields in columns... | Excel Discussion (Misc queries) | |||
| How does an address appear to have 2 fields in 1 - see sample data | New Users to Excel | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| Address is in separate fields | Excel Worksheet Functions | |||
| How do I take some of my Excel fields and make address labels? | Excel Discussion (Misc queries) | |||
Linear Mode
