Avatar of Candace Hagood
Candace Hagood
Flag for United States of America

asked on 

EXCEL remove characters in string from Right until a certain character

I have an excel sheet with many rows of serial numbers.  I need to perform a =RIGHT on the cells in one of the columns. The problem is the values vary in length. The one issue of consistency is that I need to remove everything at the end until the LAST dash.   Any ideas appreciated.

Thank you!
* Excel TableMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon