djredden73
New Member
- Joined
- Aug 10, 2012
- Messages
- 29
I have a set of data where a large text field contains a date after a specific set of words.
Example:
In [TABLE="width: 500"]
<tbody>[TR]
[TD]Text Field
[/TD]
[TD]Date (Formula)
[/TD]
[/TR]
[TR]
[TD]Here is where the large text field is and there will be a lot
of text in here.
Around this point of the text (but not always exact position) there will be this phrase:
Released Date: 30.05.2008 (this is the date format)
I would like to have an excel formula in the next cell that extracts 30.05.2008 - and preferably convert to 5/30/2008
[/TD]
[TD]5/30/2008
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Please help with a formula that can extract that for me.
Thank you
Example:
In [TABLE="width: 500"]
<tbody>[TR]
[TD]Text Field
[/TD]
[TD]Date (Formula)
[/TD]
[/TR]
[TR]
[TD]Here is where the large text field is and there will be a lot
of text in here.
Around this point of the text (but not always exact position) there will be this phrase:
Released Date: 30.05.2008 (this is the date format)
I would like to have an excel formula in the next cell that extracts 30.05.2008 - and preferably convert to 5/30/2008
[/TD]
[TD]5/30/2008
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Please help with a formula that can extract that for me.
Thank you