How do I manipulate a string to collect the address from it?

G

Guest

My string is in a notes column (exported file to excel) which includes a
variable length address separated by two distinct words (Address: and
Description) which I would like to place into three new columns.

For example, string in column is:
"'ABC Ltd Address: John Farm
Ringo Road
Milton Keynes
MK11 ABC
Description: Band members Telephone: (01908) 111111 Facsimile: (01908)
222222 Web site www.abc.com

So I would like to obtain the address as follows:
Street City Post Code
John Farm Milton Keynes MK11 ABC
Ringo Road

I would also like to split the other data into appropriate columns but I am
more concerned with the address for now.

Can anyone help please?

I have tried Text to Columns but can't work out what the delimters are as
the data is on separate lines as shown above, so no comma to use etc and
space varies. Also tried MID starting at number of characters to Address: but
don't know how to work backwards to Description.
 
R

Robnific

Yes, i remembered back in the 90's, we used this texteditor TSE to
manipulate
all kind of different data.

Eddie schreef:
 

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

how do I copy text to columns from one cell to another? 8
How can I add a character to the end of every row in Excel 2000? 6
How to split the columns 3
how to remove a character and space from a field 3
How do I set up a folder to receive email from specific account 2
How can I create a class reunion directory from a spreadsheet? 3
How do I create a name/address/phone 3-column list from Excel work 4
how to paste email address string into each cell in the spread sheet 7

Top