Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Sat, 30 Dec 2006 10:12:37 -0600, Dave Peterson
wrote: Maybe you can select the range edit|replace what: _-* (spacebar, hyphen, asterisk) with: (leave blank) replace all Thanks for a great and simple solution. I had no idea that I could use wildcards in Excel searches... (Must be a fine print in my Excel books) Thanks to all others for wonderful suggestions. I've learned a lot from this group. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
truncate | Excel Worksheet Functions | |||
truncate ssn to first four digits | Excel Discussion (Misc queries) | |||
I WANT to truncate my leading zeros | Excel Discussion (Misc queries) | |||
Truncate scientific notation | Excel Worksheet Functions |