| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rewrite name in new format
Hi there,
I have a column with numbers such as 100/16-14-059-08W6/3 100/02-16-059-08W6/3 100/15-17-059-08W6/0 100/02-18-059-08W6/2 I need these to be rewritten in a column in the following format 100161405908W6003 100021605908W6003 100151705908W6000 100021805908W6002 So basically all dashes and slashes are removed, and there is a 00 added infront of the last number. I don't want to type it in since I have a lot of numbers, how can I do this in excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| vlookup [rewrite] | Excel Discussion (Misc queries) | |||
| Decide comment format 'globally'? Restore format with ws_change? | Excel Discussion (Misc queries) | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Threaded Mode
