Combining MID, RIGHT & FIND Functions

[TommyK25]

Hey everyone,

I'm having a few issues with a formula that I'm trying to use to extract a varying amount of text from a cell;

10/01/2016 Property 5 (1) UK
12/05/2011 Property 2 Reg. 003 (1) USA
01/04/1996 Property 112 and Property 116 (1) Spain

Basically the text between the date and "(1)" (in bold) will be what I am trying to extract, though the length of this text varies a great deal. The date will always be in the above format, with the odd exception (e.g. 12/2002, omitting the day) and the "(1) will remain constant as marking the end of the required text.

I currently have been toying with the following formula which omits the date and returns the remaining text, but unfortunately have not been able to work out how to combine this with another formula to trim the text "(1)" onwards;

=MID(A1,FIND(" ",A1)+1,256)

Any help would be much appreciated!

Thanks in advance.

Tom

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

should account for varying date formats

[Olly]

Try:

Please Login or Register  to view this content.

[TommyK25]

Fantastic!

Thank you both v. much, both formulas worked perfectly

Thanks,

Tom