Скачать или смотреть Excel Concatenate Text and Dates with the TEXT function

CONCATENATE function is a popular text function in Excel. Another widely used function is the TEXT function. In this video, we look at joining text with dates. The problem with joining text and dates is the dates come over not as a date format. For example, joining the employee ID 2025, with the date November 7, 2022, will display as 202544872. What we may want to see is 2025/11-07-2022 or 2025/2022-11-07. The Text function allows us to format the date correctly. We will also look at filtering data and building a PivotTable with our helper column.

Chapters:
00:00 Introduction
00:38 A look at the data
01:34 Flash fill
03:39 Dates are numbers
04:33 Concatenate with date
05:!3 Formatting using TEXT function
06:22 Filtering the data
07:05 Building a PivotTable
07:49 Closing

#chrismenardtraining #msexcel #exceltraining

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!