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 Did you know that you can make Chapters on CZcams? 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
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.
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 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.
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
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
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
Wow, thanks. Have been meaning to do this for a while. Can I copy and paste this into the description?
@@HowToExcelBlog sure.. please do so
@@jimmylui1358 Thanks. I've added them.
@@HowToExcelBlog Did you know that you can make Chapters on CZcams? 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
Love how you clearly prepare well in advance so your explanations flow smoothly and convincingly. Thanks a ton!
Thanks! Preparing means less work filming 👍
@@HowToExcelBlog ...and easy for us viewers! 👍
Nice Excel tricks.. love it Jon.!! Raj from New Delhi
Thanks Raj!
Your second video I watch and have to say that I'm impressed by the quality. You explain very well. Thank you
Thanks! Glad you like them!
Thanks a million, it's just wonderful. Awesome and very useful. Great. 💪
Thank you so much brother 🙏 it was wonderful...
No problem. Glad you hear it's wonderful 😀
Hi John.. great summary! Learning all these will make you a text manipulation wizard! Thanks for sharing :)) Thumbs up!!
Really well done video, great job man, thank you! From Italy
Love the videos, you keep it simple with examples, great stuff! keep it up, love the videos!!
Thanks 😀
Thanks a lot . Please Create Same Tutorial like this about Time and Date Functions .🌹🌹
czcams.com/video/Pl8ezzKtBSI/video.html
Thank You
Excellent as always.
Just a request 🙏:
Please, Please, Zoom in or make your screen resolution, texts and icons bigger.
Great Tutorial..Thank You John :)
You're welcome Darryl 👍
good efforts, thanks for your time and sharing your experience
Welcome!
Awesome video, man! Very clear instructions, and simple yet attractive examples!
Thanks a million for your invaluable content.. it's just wonderful
Very well explained
Thanks!
I am super impressed.
♥️Love from 🇮🇳,sir i am learning excel
Thank you very much for this useful video!
Sir great work
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.
This is a great video, thanks! But for the love of god it's not pronounced "passta". It's pronounced "pasta"
Awesome and very useful
Glad to hear!
Thank youu!!
hello. I cannot downlod the example workbooks.
Very useful when retrieving data from web and there is a bunch of unwanted texg
Loved it
Got a lot to know..thanks!
Yes, There's a lot to know... And those are only the text functions 😮
@@HowToExcelBlogCertainly a lot to know....anyway can you illustrate the usage of UNIQUE and SEQUENCE functions?
Great video! Thank you ;-)
You're welcome Dian 🙂
thanks'
No problem!
How do you combine lower and left functions?
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
That's going to need some language AI that Excel doesn't have.
In text function, can we add formats of our own thought? Like not the std ones!!
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.
How to use nextif in word excle mail merg for multiple rows in a single letter.
Nextif? No such Excel function exists.
@@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.
Integral text func. knoweledge
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
TEXTJOIN is only on 2019 or Microsoft 365.
@@HowToExcelBlog thanks for quick response
Why my excel doesn't have textsplit, text before and text after function I'm using latest 2021 version. can anyone please help me.
Comment