Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
REPLACE or ??, Help please
Try this:
Select your range of cells EditReplace Find what: -* Replace with: (clear this space to leave it blank) Click the [Replace All] button Does that help? If not....undo! *********** Regards, Ron XL2002, WinXP-Pro "Joe Gieder" wrote: First, Thank you for all the help and support. I have a many cells similar to 01037DL530001-101 and want to remove everything from the "-" to the end. I tried replace but can't seem to get it to work. The one thing to keep in mind is that the numbers of characters or numbers varies after the dash. Thank you for your help Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace value in excel? | Excel Worksheet Functions | |||
Search and replace | Excel Worksheet Functions | |||
replace absolute references | Excel Worksheet Functions | |||
REPLACE outside of highlighted column | Excel Worksheet Functions | |||
Replace Number with Text using Macro | Excel Discussion (Misc queries) |