Trim date out of text string

**ronmhjr** · 01-24-2013, 10:46 AM

I am trying to get just the date out of a text string.

For example:

11/01/2012/Acct#39078
11/1/2012/Acct#39078

I would like for it to return:
11/01/2012
11/1/2012

Since the date length changes I am not able to use just the trim function.

Any help would be appreciated for a first time poster!

Thanks!

Ron Howard

**benishiryo** · 01-24-2013, 10:58 AM

hi Ron, welcome to the forum. is the text always starting with "Acct"? if so, try:
=LEFT(A1,FIND("/Acct",A1)-1)+0

if not, maybe:
=LEFT(A1,FIND("^",SUBSTITUTE(A1,"/","^",3))-1)+0

format cells as a date