| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default Value formatting... UK Postcodes
I want to know how to format a cell so it only takes the following
information... Char.Char,Int,Int <space Int,Char, Char So for example it would look like this... NR01 2RJ I also want the characters changed to capitals if they were entered in lowercase... I'm sure this is an easy one... but I cant find the solution anywhere... Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format of Postcodes | Excel Discussion (Misc queries) | |||
| Format of postcodes | Excel Discussion (Misc queries) | |||
| Postcodes starting with 0 | Excel Discussion (Misc queries) | |||
| Standardising Postcodes | Excel Discussion (Misc queries) | |||
| Postcodes | Excel Worksheet Functions | |||
Threaded Mode
