It worked on my test sheet David......I don't know from nothing about
"northings" and "eastings"....I just used the leading "TQ" and "TF" the OP
indicated to create my VLOOKUP table.....

Vaya con Dios,
Chuck, CABGx3


"David Biddulph" wrote in message
...
"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