| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find 1 word and replace it and leave the leading zero
I have a report with sub-totals in Excel 2003 and I have copied the
sub-totals as a paste special values to a new spread sheet and want to remove the word total and keep a leading zero that is part of our Part Numbers. is there an easy way to do that? Here's an example cell Befo 03010042 Total After I want this: 03010042 When I do a find and replace it removes the leading 0 even with the column set as a text column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
| How can I use find and replace to delete a word in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
