| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Land Locations
I want to be able to add a formula or what ever it takes to make
104063201608W402 look like this 104/06-32-016-08-W4/02 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Land Locations
=LEFT(A1,3) & "/" & MID(A1,4,2) & "-" & MID(A1,6,2) & "-" & MID(A1,8,3) & "-"
& MID(A1,11,2) & "-" & MID(A1,13,2) & "/" & RIGHT(A1,2) -- Gary''s Student - gsnu200721 "SSharp" wrote: I want to be able to add a formula or what ever it takes to make 104063201608W402 look like this 104/06-32-016-08-W4/02 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quantity survey template for proposed land for development | Excel Discussion (Misc queries) | |||
| Printing from different locations | Excel Discussion (Misc queries) | |||
| I am looking for Template for a sale of Land | Excel Discussion (Misc queries) | |||
| calculate land area | Excel Discussion (Misc queries) | |||
| breakdown of buying land and building a home costs | Excel Discussion (Misc queries) | |||
Linear Mode
