Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Excel text removal for non static strings

  • John Herguth
  • Topic Author
  • Offline
  • New Member
  • Membre nou
More
2 months 1 week ago #1485 by John Herguth
Excel text removal for non static strings was created by John Herguth
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.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo