"CLR" wrote in message
...
Assuming your number to convert is in A1, "convert" is a NamedRange of
your
T? conversions, then put this formula in B1

=(VLOOKUP(LEFT(A1,2),convert,2,FALSE)&MID(A1,LEN(A 1)-5,3))*1

And this one in C1

=(VLOOKUP(LEFT(A1,2),convert,2,FALSE)&RIGHT(A1,3)) *1

Both can be copied down as far as you have data in Column A

Are you sure that works?
Doesn't that give the same letter to number conversion for northings as for
eastings?
--
David Biddulph