extract date from string

K

kdp145

i know this is probably a really simple thing to do but i am really not
familiar with text worksheet functions. anyways i have a cell which
contains the string: "Transfer Date: 3/19/2006". i want to extract only
the date from the string e.g. "3/19/2006".

note: if it was March 1st, then it would show "Transfer Date:
3/1/2006"...so i cant use the right function since i dont know the
exact length of the date.
 
R

Ron Coderre

Try this:

For A1 containing text in the format you described
A1: Transfer Date: 3/19/2006

B1: =--TRIM(MID(A1,FIND(":",A1)+1,255))
Format B1 as a date.

Does that help?

Regards,
Ron
 
B

Beege

kdp

Select cells, Data/Text to Columns/Fixed Length.
Separate words and space from date, format as date
You can choose to not import the text part.

HTH
Beege
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract Date from Right Formula 3
extract date from text 19
data extract 7
How do I grab the date from a text string? 4
How to extract a character from a string then VLOOKUP a table? 7
identifying data from a separate worksheet 1
Return across Row Numeric Values Matching EXACT Month & Year for Criteria 8
Excel - Changing value of a date by a number of calendar months 3

Top