ExcelBanter - Edit numerous cell entries

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Edit numerous cell entries (https://www.excelbanter.com/excel-worksheet-functions/149616-edit-numerous-cell-entries.html)

raywood

Edit numerous cell entries

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

PCLIVE

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

All times are GMT +1. The time now is 08:47 PM.