LinkBack URL
About LinkBacks
I need to convert data that looks like this 08162008 it's formated as text and needs to look like this 08/16/2008 there are multiple dates and years within this field.
I need to convert data that looks like this 08162008 it's formated as text and needs to look like this 08/16/2008 there are multiple dates and years within this field.
Try this - where a1 has your text format date data.
Please Login or Register to view this content.
Last edited by GuruWannaB; 03-19-2009 at 12:07 PM. Reason: condensed formula part of left(right(a1,6),2) to mid(a1,3,2)
I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!
Please mark your threads as Solved once it is solved. Check the FAQ's to see how.
Try this:
Please Login or Register to view this content.
ExlGuru
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks