Forum Discussion
Excel- Delete numbers and specific characters and keeping words
Hello everyone, I have a problem with finding a formula. There is this this column, all cells have specific different words, some cells have only words, others have words and end up with "(2)" or "...
If some cells end with (number), then use this formula:
=IFERROR(LEFT(A2,
FIND(“(“,A2)-1),
A2)
=IFERROR(LEFT(A2,
FIND(“(“,A2)-1),
A2)