| Home |
| Search |
| Today's Posts |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & replace question.....I believe
Another nice option.
Ron Coderre wrote: Dave If *_ is replaced wth an apostrophe, any leading zeros after the underscore will be preserved. (although, the remaining characters will be text...if that's OK with the OP) 8710050132_0064 would become 0064 *********** Best Regards, Ron XL2002, WinXP "Dave Peterson" wrote: Select the range edit|replace what: *_ with: (leave blank) replace all However, this will change: 8709300242_0023 to just plain old 23 But you could give the cells a custom format of 0000. anorton wrote: Hi all, I would like to see if there is a way to modify the numbers in a cell to only show a partial? For example: 8709300242_4576 8710010110_4550 8710010157_4580 8710050132_4564 I want to only show: 4576 4550 4580 4564 Thanks. -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and replace - problem with automatically changing formatting | Excel Discussion (Misc queries) | |||
| Find and Replace | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Find and replace of word causes change of font formatting | New Users to Excel | |||
| how to find and replace a symbol in my worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
