Formula opposite Concatenate

Ladkisson
Ladkisson used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Just use format date and select English USA as short date, that is it




Regards

Chris
Dates-format.xlsx
Finance Analyst
Commented:
With the text string 02APR2017:00:00:00.000 in C4 use:

=DATEVALUE(LEFT(C4,9))

Then format as Short Date

Author

Commented:
Perfect! Thanks!
Rob HensonFinance Analyst

Commented:
Glad to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial