Thread: [Solved] Convert text to date format
View Single Post
 
Old 11-14-2015, 03:52 PM
shg shg is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
  
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default
Quote:
Originally Posted by klllmmm View Post
You mean divide this data in one cell to 3 separate cells, then can I combine to get date format? ( may use "& function" or concatenate)
No.

1. Select the column

2. Select the Data tab

3. Press the Text to columns button.

4. Press Finish.
Reply With Quote