USE THE TEXT FUNCTION TO EXTRACT DATE PARTS USING MICROSOFT EXCEL
A worksheet contains date values in column A as text that cannot be interpreted by Excel as date values. As in the previous example, the text has to be extracted, but the result should be specially formatted as shown in the screenshot below.
A worksheet contains date values in column A as text that cannot be interpreted by Excel as date values. As in the previous example, the text has to be extracted, but the result should be specially formatted as shown in the screenshot below.
To extract, combine, and show specially formatted date:
1. Select cells B2:B10 and type the following formula: =TEXT(DATE(RIGHT(A2,4),MID(A2,3,2),MID(A2,1,2)),"YYYY-MM-DD").
2. Press <-Ctrl+Enter->.
USE THE TEXT FUNCTION TO EXTRACT DATE PARTS USING MICROSOFT EXCEL |
Watch the Video Tutorial - https://www.youtube.com/watch?v=5kvFLr2MjqI
No comments:
Post a Comment