Highlight your date strings and run Data -> Text to Columns -> Delimited proceed to Step 3 -> choose Date and option MDY -> click Finish.
Highlight your date strings and run Data -> Text to Columns -> Delimited proceed to Step 3 -> choose Date and option MDY -> click Finish.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Sorry what to do after Delimited? There are some options like tab, semicolon, comma, space, and other. Which option needs to be select?
This site work as
![]()
![]()
![]()
![]()
![]()
![]()
Just leave as default and proceed to Step 3 as advised - click Finish once you have configured Step 3.
Now its Done thanks
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks