Covert Text date to date in Excel

[bigroo1958]

I would like help on converting this text string:

Please Login or Register  to view this content.

to 01/25/2019 in excel.
How would I do this?

Thanks

[Phuocam]

Try this:

=--REPLACE(A1, 1,FIND(",",A1)+1,"")

[bigroo1958]

Great Phuocam, that worked, can you please explain the formula?

[bigroo1958]

What does the 2 dashes do after the equals sign at the beginning of the formula, I have worked out the rest?
Thanks

[Haluk]

The 2 consecutive dashes converts the string result to numeric.

[Phuocam]

Using (--) is the same as VALUE (), DATEVALUE (), converting text to number.

It is like this:

=VALUE(REPLACE(A1, 1,FIND(",",A1)+1,""))

or

=DATEVALUE(REPLACE(A1, 1,FIND(",",A1)+1,""))

[bigroo1958]

Thank you all for the replies!!
This helps me a lot!