Combining a RIGHT and a LEFT formula?

[gregory_1977]

I would like to combine:

=Right(A1,LEN(A1)-FIND("-",A1))

and

=LEFT(A1,LEN(A1)-4)


To Result in: WINTER PARK
From:ORLANDO RV-WINTER PARK, FL

I need to drag down the formula to work with multiple locations, thus the FIND "-"

Many Thanks!

 

[Jeffrey Mahoney]

Please try

=Right(A1,LEN(A1)-FIND("-",A1))&LEFT(A1,LEN(A1)-4)

 

[Jonmo1]

Try

=REPLACE(LEFT(A1,LEN(A1)-4),1,FIND("-",A1),"")

 

[AlKey]

Or this

[B]=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,",","-"),"-",REPT(" ",50)),50,50))[/B]

 

[Rick Rothstein]

Here is one more for you to consider...

=MID(LEFT(A1,LEN(A1)-4),FIND("-",A1)+1,99)

 

[gregory_1977]

Thanks guys! I used Rick's and Jonmol1's suggestions and both worked like a charm. Cheers!