How to use excels textafter if delimiter is a slash or backslash

Question

Excell

sample 1

Cell A1 = 3/4/72

cell A2 = textafter(A1,"/")

fails w "N/A"

example 2

Cell A1 = 3@4@72

cell A2 = textafter(A1,"@")

works fine

How do I enable textafter to search for "/"

Answer 1

@Bennie Larrier ,

In you first example, the value of the cell is 26362. It is only displayed as a date because of formatting. Try setting A2 to = textafter(text(A1,"mm/dd/yyyy"),"/")

Answer 2

Hi @Bennie Larrier,

In this case, slash or backslash cannot be recognized by Textafter() function. This is by default. I would suggest you find and replace all slashes or backslashes to other characters which can be recognized by Textafter like "@".

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.