18 Text Functions in Excel You Need to Know

Подписаться 64 тыс.

Просмотров 134 тыс.

50% 1

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:
👉 www.howtoexcel.org/courses/
DOWNLOAD any example workbooks here:
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks.
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social:
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 65

@HowToExcelBlog 4 года назад

Check out my full courses and ebooks here 👉 www.howtoexcel.org/courses/

@rgarlinyc 4 года назад

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

@HowToExcelBlog 4 года назад

Thanks! Preparing means less work filming 👍

@rgarlinyc 4 года назад

@@HowToExcelBlog ...and easy for us viewers! 👍

@jimmylui1358 4 года назад

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

@HowToExcelBlog 4 года назад

Wow, thanks. Have been meaning to do this for a while. Can I copy and paste this into the description?

@jimmylui1358 4 года назад

@@HowToExcelBlog sure.. please do so

@HowToExcelBlog 3 года назад

@@jimmylui1358 Thanks. I've added them.

@guest273 Год назад

@@HowToExcelBlog Did you know that you can make Chapters on RU-vid? You'd have to slightly reformat the description of your video from: 1. CHAR function 0:17 2. TRIM function 1:29 3. EXACT function 2:39 to something like this: 0:00 - 0. Intro 0:17 - 1. CHAR function 1:29 - 2. TRIM function 2:39 - 3. EXACT function

@dannybans23 3 года назад

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

@wayneedmondson1065 4 года назад

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

@raidahzarinkhan3593 Год назад

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

@amirmoezi8316 2 года назад

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

@Rokinso 3 года назад

Thank you very much for this useful video!

@matrix3904 4 года назад

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

@HowToExcelBlog 4 года назад

Thanks 😀

@user-hb2df6nn2y 3 месяца назад

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

@arnabsaha33 2 года назад

I am super impressed.

@darrylmorgan 4 года назад

Great Tutorial..Thank You John :)

@HowToExcelBlog 4 года назад

You're welcome Darryl 👍

@spatelprinting496 2 года назад

Thank You

@dastageera9626 4 года назад

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

@HowToExcelBlog 4 года назад

No problem. Glad you hear it's wonderful 😀

@surbanoclarabel5544 8 месяцев назад

Thank youu!!

@Foreman1329 3 года назад

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

@HowToExcelBlog 3 года назад

Thanks! Glad you like them!

@mblanco83 Год назад

Loved it

@pujashakya691 2 года назад

Sir great work

@RajendraPatel. 4 года назад

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

@HowToExcelBlog 4 года назад

Thanks Raj!

@sameh1180 3 года назад

good efforts, thanks for your time and sharing your experience

@HowToExcelBlog 3 года назад

Welcome!

@Sivakumarpoornima 3 года назад

Awesome and very useful

@HowToExcelBlog 3 года назад

Glad to hear!

@DianHrozek 4 года назад

Great video! Thank you ;-)

@HowToExcelBlog 4 года назад

You're welcome Dian 🙂

@jeylanm3133 4 года назад

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

@HowToExcelBlog 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Pl8ezzKtBSI.html

@supportmarathi 2 года назад

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

@alinaqvi6203 3 года назад

Very well explained

@HowToExcelBlog 3 года назад

Thanks!

@mojtabareyhani7905 Год назад

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

@walidkhlil2872 4 года назад

thanks'

@HowToExcelBlog 4 года назад

No problem!

@stacyjens8256 2 года назад

So this video gives me hope. The function‘substitute’ reads the sentence and replaces a word within the sentence. I’ve been trying to find a formula to read a row of words to find a specific word and return all of the rows data. I cannot find any help with this and I’ve watched hours and hours of videos. This gives me hope that I’ll find it! Thank you.

@camerongray7767 2 года назад

Very useful when retrieving data from web and there is a bunch of unwanted texg

@powerranger6731 4 года назад

Got a lot to know..thanks!

@HowToExcelBlog 4 года назад

Yes, There's a lot to know... And those are only the text functions 😮

@powerranger6731 4 года назад

@@HowToExcelBlogCertainly a lot to know....anyway can you illustrate the usage of UNIQUE and SEQUENCE functions?

@bradhudson5811 Год назад

This is a great video, thanks! But for the love of god it's not pronounced "passta". It's pronounced "pasta"

@sk3master144 Год назад

Integral text func. knoweledge

@mstodoric 2 месяца назад

How do you combine lower and left functions?

@steniorodrigo5590 2 года назад

hello. I cannot downlod the example workbooks.

@jlpayne052710 3 года назад

This seems so close to what I’m trying to do but it doesn’t seem to do what I need I’m looking for almost the inverse in text( e.g. “Mike will send Tom red apples “in one cell and “Tom will receive red apples from Mike” in another cell and I want them to appear side by side in separate cells

@HowToExcelBlog 3 года назад

That's going to need some language AI that Excel doesn't have.

@rakeshkumaryadav4423 4 года назад

In text function, can we add formats of our own thought? Like not the std ones!!

@HowToExcelBlog 4 года назад

Not sure what you mean by not standard? Those where all custom formats shown, like the phone number format I'd say is not standard.

@anupshah09 4 года назад

Hi I am using Ms office professional plus 2016, text join function is not there in it. Can u tell from which version this new functions are included. Plz guide. Thank you

@HowToExcelBlog 4 года назад

TEXTJOIN is only on 2019 or Microsoft 365.

@anupshah09 4 года назад

@@HowToExcelBlog thanks for quick response

@straightsimplesteps8836 4 года назад

How to use nextif in word excle mail merg for multiple rows in a single letter.

@HowToExcelBlog 4 года назад

Nextif? No such Excel function exists.

@straightsimplesteps8836 4 года назад

@@HowToExcelBlog yea i know i am asking about how to use nextif code in word with excel data for multiple row mail merge?? I couldn't found any good answer on the web.