View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Gieder
 
Posts: n/a
Default REPLACE or ??, Help please

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