Quote:
Originally Posted by Matt Smith  Similarly, if you are sending in data on a spreadsheet, put the grid ref in a single cell and never split it over 2 or 3 cells (ie "SU" "123" "456"). I (and I am sure a lot of other recorders) spend a lot of time fiddling with grid refs on speadsheets to get them to read "SU123456", removing spaces or combining spreadsheet cells to get them into a state where we can actually use them. |
This is something I have had to contend with, try some of the string handling formulae, "concatenate" is really helpful to get bits of things and join them up, "left" and "right" combined with numbers can be very useful. I think they are string handling in excel, in Open Office they are text functions. I spent a happy half hour with records fom various sources, about 6000 records with all sorts of ways of recording co-ordinates, and got a formula that sorted them out or flagged an error, time well spent.