ExcelBanter - Land Locations

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Land Locations (https://www.excelbanter.com/excel-discussion-misc-queries/142646-land-locations.html)

SSharp

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

Gary''s Student

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

All times are GMT +1. The time now is 03:30 AM.