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

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.

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

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

Eddie schreef:

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.