If Right Left Query

Try

=LEFT(A1,7-(RIGHT(A1)=1))

If you want a - in there too

=LEFT(A1,6)&IF(RIGHT(A1)=1,"","-"&RIGHT(A1))

Thanks daddy but it's failing on the =1

even if I put >1 it does not work.

for some reason it is not looking at the 7th digit and recognising it as equalling 1 (or greater than 1 when in input >1)....

Any more ideas greatly appreciated

Thank you very much

see tony's solution.....or my revision..... Because RIGHT function returns text

=RIGHT(A1) will never equal 1, it will be "1"

Legends the two of you!

Many Thanks for the solution

Have a GREAT DAY!