filmov
tv
How to extract text before or after character in Excel
Показать описание
How to extract text before or after a character in Excel?
In this tutorial, I'll show you how to extract text before or after a character in Excel using functions and formulas. If you are working with Excel 2013, Excel 2016, or Excel 2019, use the LEN, LEFT, FIND, and RIGHT functions. For Microsoft 365 subscribers, we recommend using the new TEXTAFTER and TEXTBEFORE functions.
Chapters:
0:00 Intro
0:08 Extract text before a character in Excel
0:41 Extract text after a character
1:18 TEXTBEFORE function
1:35 TEXTAFTER function
1:46 Thank you
#msexcel #excel #exceltips #exceltricks #excelformula #excelfunctions #productivity #datacleaning #datacleansing
In this tutorial, I'll show you how to extract text before or after a character in Excel using functions and formulas. If you are working with Excel 2013, Excel 2016, or Excel 2019, use the LEN, LEFT, FIND, and RIGHT functions. For Microsoft 365 subscribers, we recommend using the new TEXTAFTER and TEXTBEFORE functions.
Chapters:
0:00 Intro
0:08 Extract text before a character in Excel
0:41 Extract text after a character
1:18 TEXTBEFORE function
1:35 TEXTAFTER function
1:46 Thank you
#msexcel #excel #exceltips #exceltricks #excelformula #excelfunctions #productivity #datacleaning #datacleansing
0:00:36
0:02:25
0:01:55
0:02:55
0:05:26
0:06:11
0:14:50
0:16:43
0:53:43
0:00:31
0:02:03
0:04:08
0:06:24
0:01:51
0:13:48
0:00:50
0:07:15
0:05:55
0:03:09
0:01:05
0:07:28
0:12:05
0:09:18
0:03:03