Issue
Hi everyone,
My goal is to remove the integer behind the name (if exist) as shown in the screenshot above. Is there any trick to do this other than doing it manually? It is challenging for me because the name list is not consistent as some of the names does not have integer behind. Any help will be greatly appreciated!
Solution
In your situation, how about the following sample formula?
Sample formula:
=ARRAYFORMULA(REGEXREPLACE(A3:A,"\d+$",""))
Result:
Note:
- If you want to use
TRIM
for the value, how about=ARRAYFORMULA(TRIM(REGEXREPLACE(A3:A,"\d+$","")))
?
Reference:
Added:
From OP's following replying,
Hi Tanaike, thanks for your input. I tested both formula. It works most of the time with the exception of
Derrick Tan 1
. Beside that, is it possible to remove the-
as well if exist? I edited my question with new screenshot example, thank you.
In this case, how about the following sample formula?
Sample formula:
=ARRAYFORMULA(TRIM(REGEXREPLACE(A3:A,"[-\s\d]+$","")))
Result:
Answered By - Tanaike Answer Checked By - Dawn Plyler (PHPFixing Volunteer)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.