Dear all,
I have elaborated the question in the sample workbook.
Thank you.
Dear all,
I have elaborated the question in the sample workbook.
Thank you.
Hi,
The following works for your example.
=DATE(RIGHT(A2,4),LEFT(A2,2),MID(A2,4,2))
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
You can use:
and copy downPlease Login or Register to view this content.
other option is to use "text to columns" tool from data ribbon - make sure you mark column1 ad date with MDY format
Last edited by Kaper; 06-23-2020 at 03:09 AM.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks