Ladkisson
asked on
Formula opposite Concatenate
Hello,
I have a text extract that needs to be converted to regular date format. For example: 02APR2017:00:00:00.000 needs to be 4/2/17
thanks!
I have a text extract that needs to be converted to regular date format. For example: 02APR2017:00:00:00.000 needs to be 4/2/17
thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thanks!
Glad to help.
Regards
Chris
Dates-format.xlsx