Land Locations

S

SSharp

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
 
G

Gary''s Student

=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)
 
Top