filmov
tv
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 ---------------------------------
-- SOFTWARE USED ---------------------------------
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!
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 ---------------------------------
-- SOFTWARE USED ---------------------------------
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!
0:05:04
How to Concatenate a Date with Text in Excel 2016
0:00:57
How to Concatenate Text with Dates in Excel | MS Excel Tutorial
0:08:28
Excel Concatenate Text and Dates with the TEXT function
0:04:30
How to combine text and date in the same cell | Concatenate date and text | Add date and text
0:03:18
Concatenate date and text with date format
0:04:58
Concatenate a Date with Text in Excel
0:01:16
How To Concatenate Text in Google Sheets (text + date)
0:03:45
Quickly Concatenate Multiple Cells - Combine Cells with commas, space and semicolon
0:02:33
How to concatenate dates in Microsoft Excel using the TEXT Function?
0:07:31
Easily Combine Text & Numbers into ONE Cell in Excel | NO CONCATENATE
0:05:29
Concatenate Excel Tutorial
0:02:09
How to combine date and time columns in Excel
0:02:23
Google sheets - Combine Date and Time columns into one column | Concatenate & Text Formula
0:02:46
how to concatenate date or date of birth in excel by using excel formula .
0:12:38
How Excel Concatenate Date Value and Text | @TechhDesignn
0:01:50
Combine text and dates using Concatenate (& Operator ) and Text Function
0:01:43
Concatenate text in Excel
0:00:59
How to concatenate keeping number/ date formatting in Excel
0:03:06
How to concatenate date and time values together in Microsoft Excel? MS Excel Tutorial #23
0:02:03
How to Concatenate Cells and keeping Date Format in Excel
0:00:59
How to Concatenate Text and Date in Excel || Concatenate two values in Excel #shortvideos #shorts
0:07:53
CONCATENATE vs CONCAT vs TEXTJOIN formula in Excel | Understand the difference!
0:00:53
Concatenate Date and Time.
0:03:13
How to Concatenate Text With Date
Комментарии