I have sourced some UK climate data from a voluntary organisation of UK meteorologists. They have masses of data and I have offered to help them give the stuff some sort of geographic context and encourage them to put at least some of it public domain. my first hurdle is geocoding they have given me a list of weather stations from which I intend to geocode the data. there are 4 fields that interest me 1 and 2 are station name and ID number 3 gives the OS sheet tile ref eg SJ and the 4th is the combined easting and northing co-ordinates. I need to turn this sort of number SJ | 095734 into 309500 | 373400 which is the proper east north Ordnance Survey co-ordinate as understood by mapinfo I have split such numbers before to make 2 columns using excel but only when the tiles where SH and SJ so it was easy to sort those numbers needing a 2 or 3 in front. In this case I don't even know what the values are for the remaining tiles. I am hoping that someone out there can give me a pointer or values to work to although I imagine it is likely some soul out there in the UK land may well have encountered this before and can allow me use of an mbx to knock the job off thanks for any help see you folks Adrian PS UK users dont forget Mapinfo User Group Wales and West meet at the International Pavilion in Llangollen on Thursday 23 Nov 2000 see you there -- ****************************************************************************** * _ * * |_|/~\----^\_ Adrian Walls, North Wales * * _/_ * :. 14 Tyn Llan,Llanferres,Denbighshire,CH7 5SP, UK * * // | :' [EMAIL PROTECTED] * * - \ : [EMAIL PROTECTED] * * / : http://www.nwmba.demon.co.uk * * \ : [EMAIL PROTECTED] * * / : AOL Instant Message Username : MacMTBman * * __/ : * * /~ :. (web mail) [EMAIL PROTECTED] * * ~\-__ : * * `--_ ___- : * * \___/ * ****************************************************************************** _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.