Edit numerous cell entries
One way:
=LEFT(A1,2)&"/"&MID(A1,3,2)&"-"&MID(A1,5,2)&"-"&MID(A1,7,3)&"-"&MID(A1,10,3)&"/"&RIGHT(A1,3)
HTH,
Paul
"raywood" wrote in message
...
I have numerous cell entries all the same length ie:( 21071303129W300)
I need to edit the entries with slashes and dashes as shown here
21/07-13-031-29W3/0...how can I acomplish this in excel without manually
editing each entry cell by cell?
--
raywood
|