| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rationalising grid references
In an Excel spreadsheet I have 200,000 (two hundred thousand) Ordnance Survey
(UK) grid references in the format AB1234567890 (ie a 10-figure reference). I need to reduce these to a two-figure reference (ie AB16). Is there a way of doing this other than manually? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel insits that I use absolute cell references | Excel Discussion (Misc queries) | |||
| Partial Grid Lines | Excel Discussion (Misc queries) | |||
| More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
| grid & grid refrences | New Users to Excel | |||
Threaded Mode
