Cell Formatting

[Raja]

I currently have cell which looks like this:
108131407004W400

and I would like it to look like this:
108/13-14-070-04W4/00

I tried some LEFT, &, RIGHT Statements, but I can't get
this format, any help would be greatly appreciated

Thanks,
Raj

 

[J.E. McGimpsey]

One way:

=TEXT(LEFT(A1,12)*1,"000\/00-00-000-00") & MID(A1,13,1) &
TEXT(RIGHT(A1,3)*1,"0\/00")

 

[Dan E]

Why should I be an investigator???

Hey Dan,

Thanks for your help I guess I missed the MID function

You should be an investigator
Thanks,
Raj


& "-" & MID(B12,8,3) & "-" & MID(B12,11,4) & "/" & RIGHT
(B12,2)