Extracting text

[howard]

I have the following text

Castle 159-71 Court

I want extract the text Castle as well as Court i.e. 4 characters before the - and 3 characters after the dash

I have used the following formula by cannot get it to work

=LEFT(A17,FIND("-",A17)-4),TRIM((RIGHT(A17,FIND("-",A17)-5))

Your assistance will be most appreciated

 

[Seti]

Try this:

=LEFT(A17,FIND("-",A17)-4)&TRIM(RIGHT(A17,FIND("-",A17)-5))

You used a comma to catenate when it should have been an & and you had messed up parens.

 

[bebo021999]

I have the following text

Castle 159-71 Court

I want extract the text Castle as well as Court i.e. 4 characters before the - and 3 characters after the dash

I have used the following formula by cannot get it to work

=LEFT(A17,FIND("-",A17)-4),TRIM((RIGHT(A17,FIND("-",A17)-5))

Your assistance will be most appreciated

You can use:

=LEFT(D1,FIND("-",D1,1)-4)&" "&RIGHT(D1,LEN(D1)-FIND("-",D1)-3)

to get "Castle Court" as result.

 

[Misca]

Try:
=LEFT(A1,FIND("-",A1)-4)
and
=TRIM(MID(A1,FIND("-",A1)+3,LEN(A1)))

 

[howard]

Hi Guys

Thanks for the help, much appreciated