Extracting data from a string using conditions

[Terry-J]

Hi,

I have the following data and I want to extract the test either side of the "-".

So:
ABC-A56-Portman Rd
AFG-A56a-Smith Street
ACD-A486b-Dalbeattie Street.

I have tried the LEFT & RIGHT Functions but I am struggling with getting the data out in between the "-" & "-"
S0 - A56, A56a, A486b

Any ides?

Terry

[JohnTopley]

If they all start as AAA-

try

=MID(SUBSTITUTE(A1,"-","|",2),5,FIND("|",SUBSTITUTE(A1,"-","|",2))-5)

[Terry-J]

Hi John,

That works fine,

Thanks very much.

T.