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

E

Eddie

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

Extracting Numerals From a Text String? 1
How do I extract a string from an IP address in Excel? 2
How to retrieve certain text from string? 5
How do I change the headings from A1 A2 etc to show my headings? 3
Bring data from header fields to the columns 3
How can I add a character to the end of every row in Excel 2000? 6
How do I find only number caracter in a string? 1
How do I consolidate data from several spreadsheets into one. 4

Top