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