Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel: How to fix date format problems - Text to Columns, Concatenate & more. That video is uploaded by Geosearch International at 2022-01-13T03:02:17-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [8L_hlgkWqtQ]
| Name | Excel: How to fix date format problems - Text to Columns, Concatenate & more |
| Video Uploader | Video From Geosearch International |
| Upload Date | This Video Uploaded At 13-01-2022 11:02:17 |
| Video Discription | Why does Excel not recognise some dates as numbers? How can I fix it? In this video I'll show you how to break up badly formatted dates using Data - Text to Columns, and how to stitch it back together using the CONCAT() function. We will format it is a table and finally produce a quick line chart of the data. Chapters: 00:00 Introduction 00:16 Check if data is number or text 01:14 Trick to change text to numbers 01:30 Text to Columns 02:24 Format as Table 02:46 The CONCAT() function 03:51 Copy-Paste123 to remove formulas 04:24 Insert line chart 05:56 Smoothing the lines 06:35 Final remarks Link to the Excel file used in the video: https://bit.ly/33viW46 #Excel #TextToColumns #CONCAT 8L_hlgkWqtQ |
| Category | Education |
| Tags | Excel | Text to Columns | CONCAT() | Line chart | smooth line chart | Andreas de Jong | Geosearch International | Date formats |
