| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rewrite name in new format
You could do it using Find & Replace (CTRL-H). Highlight the column
containing your data and do CTRL-H (or Edit | Replace): Find What: 100/ Replace with: 100 click Replace All CTRL-H again: Find What: W6/ Replace with: W600 click Replace All CTRL-H again: Find What: - Replace with: leave blank click Replace All Hope this helps. Pete On Feb 6, 4:33*pm, ALaw wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
