18 Text Functions in Excel You Need to Know

preview_player
Показать описание
Learn the top 18 text functions in Microsoft Excel that you need to know.

1. CHAR function 0:17
2. TRIM function 1:29
3. EXACT function 2:39
4. CONCAT function 4:09
5. TEXTJOIN function 5:53
6. TEXT function 9:05
7. LOWER function 10:44
8. UPPER function 11:28
9. PROPER function 12:00
10. LEFT function 12:55
11. RIGHT function 14:02
12. MID function 15:02
13. LEN function 16:12
14. REPT function 16:54
15. FIND function 17:44
16. REPLACE function 19:45
17. SEARCH function 21:13
18. SUBSTITUTE function 22:59

Check out my full courses and ebooks here:

DOWNLOAD any example workbooks here:

SUBSCRIBE & get my 3 FREE eBooks.

CONNECT with me on social:

Thanks for all your support!
  1. How To Excel
  2. Microsoft Excel
  3. Excel
  4. Microsoft
  5. Tutorials
  6. Functions
Рекомендации по теме
18 Text Functions 0:24:58

18 Text Functions in Excel You Need to Know

How To Use 0:07:38

How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next Project

Use the Excel 0:10:11

Use the Excel TEXT Function to Display Numbers as Words

How to use 0:05:45

How to use the TEXT Function in Excel

MS Excel | 0:19:28

MS Excel | Text Functions

Change number in 0:00:24

Change number in date format | Excel formulas | Text Function

TEXT FUNCTION (ADVANCE 0:00:25

TEXT FUNCTION (ADVANCE EXCEL FUNCTION)(shorts)

These are the 0:11:49

These are the most important Excel Text Functions you *NEED* to know

Learn Python basics, 10:38:12

Learn Python basics, functions, classes, Numpy and Pandas session 323

New Excel TEXTSPLIT 0:07:28

New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips)

3 NEW Excel 0:10:04

3 NEW Excel Text Functions I wish I had years ago!

TEXT Function in 0:04:21

TEXT Function in Excel - Tutorial

6 Must Know 0:13:52

6 Must Know Text Manipulation Extraction Functions in Excel - With Examples

Microsoft Excel Tutorial 0:10:37

Microsoft Excel Tutorial - Text Functions in Excel | Excel TEXT Function - Formula and Examples

Excel String (Text) 0:05:35

Excel String (Text) Functions and Formulas Tutorial

Excel formula to 0:00:42

Excel formula to extract the last word from a cell

Concatenate - Concatenate 0:00:59

Concatenate - Concatenate Formula in Excel

Excel Formulas and 0:52:40

Excel Formulas and Functions | Full Course

how to use 0:00:34

how to use wrap text in excel?

Text Functions in 0:18:22

Text Functions in Excel : 14 different functions covered

How to wrap 0:00:19

How to wrap text in excel

Convert date into 0:00:11

Convert date into month text formula #shorts #excel #exceltips

Concatenate formula in 0:00:16

Concatenate formula in excel

How to Extract 0:16:43

How to Extract Part of Text String from an Excel Cell

Комментарии
Автор

Check out my full courses and ebooks here

HowToExcelBlog
Автор

good to have timestamp next to the function for easy navigation
1. CHAR function 0:17
2. TRIM function 1:29
3. EXACT function 2:39
4. CONCAT function 4:09
5. TEXTJOIN function 5:53
6. TEXT function 9:05
7. LOWER function 10:44
8. UPPER function 11:28
9. PROPER function 12:00
10. LEFT function 12:55
11. RIGHT function 14:02
12. MID function 15:02
13. LEN function 16:12
14. REPT function 16:54
15. FIND function 17:44
16. REPLACE function 19:45
17. SEARCH function 21:13
18. SUBSTITUTE function 22:59

jimmylui
Автор

Love how you clearly prepare well in advance so your explanations flow smoothly and convincingly. Thanks a ton!

rgarlinyc
Автор

Nice Excel tricks.. love it Jon.!! Raj from New Delhi

RajendraPatel.
Автор

Your second video I watch and have to say that I'm impressed by the quality. You explain very well. Thank you

Foreman
Автор

Thanks a million, it's just wonderful. Awesome and very useful. Great. 💪

raidahzarinkhan
Автор

Really well done video, great job man, thank you! From Italy

hbdfnny
Автор

Thank you so much brother 🙏 it was wonderful...

dastageera
Автор

Excellent as always.
Just a request 🙏:
Please, Please, Zoom in or make your screen resolution, texts and icons bigger.

mojtabareyhani
Автор

Love the videos, you keep it simple with examples, great stuff! keep it up, love the videos!!

matrix
Автор

good efforts, thanks for your time and sharing your experience

sameh
Автор

Hi John.. great summary! Learning all these will make you a text manipulation wizard! Thanks for sharing :)) Thumbs up!!

wayneedmondson
Автор

♥️Love from 🇮🇳, sir i am learning excel

supportmarathi
Автор

Thank you very much for this useful video!

Rokinso
Автор

How do you combine lower and left functions?

mstodoric
Автор

Awesome video, man! Very clear instructions, and simple yet attractive examples!

dannybans
Автор

Thanks a lot . Please Create Same Tutorial like this about Time and Date Functions .🌹🌹

jeylanm
Автор

Thanks a million for your invaluable content.. it's just wonderful

amirmoezi
Автор

Can textjoin retain the formatting (e.g. bold and italics) of the source cell?

CarolynMartin-oovz
Автор

Thank you and Lord Christ bless you, beloved. Take care.

PslamJesusIsLord