Separating Date from Text in One Cell

[Tracy2573]

Hello, I have text then a date in one cell and I would like to extract just the date portion into a separate cell. Is there a formula to do this instead of doing the Text to Columns every time I update my data?

The cell I am trying to separate looks like this:

Ticket # 14979 02/17/2022

I would like to have 02/17/2022 put into another cell on its own.

Sometimes the text will look like this if space is missed:

Ticket# 14979 02/17/2022

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also is the date always the last part of the string?

 

[lrobbo314]

Book1 (version 2).xlsb
	A	B
1	Ticket # 14979 02/17/2022	2/17/2022
Sheet5

Cell Formulas
Range	Formula
B1	B1	=EXD(A1)

Function EXD(d As String) As Date
With CreateObject("VBScript.RegExp")
    .Pattern = "(?:\d{1,2}\/)+\d{2,4}"
    EXD = .Execute(d)(0)
End With
End Function

 

[Tracy2573]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also is the date always the last part of the string?

I just did that thanks, and yes the date is always at the end

 

[Fluff]

Thanks for that. How about

=DATEVALUE(RIGHT(A2,10))