Hello,
I am looking for an "If" statement formula which can take a cell and judge whether the second character is a number and then remove the first two characters if it is not number. If it is a number then nothing will be done.
Exaple for the cell to judge:
2A25KL-AAACB --> (this would remove first two characters)
25KL-AAACB --> (this would do nothing)
Any help would be greatly appreciated.
Thanks!
Bookmarks