unanswered Excel text removal for non static strings

More
1 year 4 months ago #1485 by jherguth
Hi,
I have a couple issues that Im in need of help with. The first is removing text from each cell in a column when it is delimited by '-'

I want to remove everything after the last '-'

Something like this:

thing1-thing1a-sometext
thing1-thing1bbb-sometext
thing2-thing2aajah-sometext

So, in this example, how would I remove 'sometext' from each of the above cells?

Thank you!

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun