| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to edit WordArt entries? | Excel Discussion (Misc queries) | |||
| Extracting cell data from numerous files in multiple folders???? | Excel Worksheet Functions | |||
| Sum of cell on numerous worksheets in a workbook | Excel Worksheet Functions | |||
| Find and edit column entries | Excel Discussion (Misc queries) | |||
| How do you merge data from numerous cells into just one cell? | Excel Discussion (Misc queries) | |||
Linear Mode
