We have additional free Microsoft Excel training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & How to Create a Dashboard in Excel here 👉kzitem.info/door/PLzj7TwUeMQ3g1WJPlf-mojgdR3gN-JWIz 🔥Check out our FREE 300+ hour training course playlist here ➡ kzitem.info/door/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@hstevenadams1202
Жыл бұрын
The absolute best on-screen tutorial I've ever seen. Well described and all steps and transitions were smooth and professional. Wherever you work, I hope you're paid well, and you deserve a raise and a bonus.
@SimonSezIT
Жыл бұрын
Wow, thanks! So glad you enjoyed it 😊 Additional Excel tips here if you need them -> kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@jot2000
2 жыл бұрын
I really like the incremental approach this teacher is teaching, very helpful. Was able to understand and do even some complex strings.
@MarthaBHamilton
Жыл бұрын
THIS WAS FABULOUS. I appreciate the way you showed how to extract each part of the data, and then how to substitute the formulas in the larger formula. thank you
@Manohar.K1999
7 ай бұрын
Thanks for this tutorial. I've searched many videos but didn't find what I needed. In this video, I've cleared all my doubts.
@SimonSezIT
7 ай бұрын
You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzitem.info/door/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@jamlecknjagi842
Жыл бұрын
Best step by step progression in an excel fomular I've ever seen.
@SimonSezIT
Жыл бұрын
Glad you liked it!
@JonnieLingo
2 жыл бұрын
Your method is simple and basic. You explain it well without going over everyone's head. I'm taking a class and your example was so much easier than what I was taught.
@SimonSezIT
2 жыл бұрын
Thank you Norman, we appreciate your comments!
@user-kr3uw2om1b
10 ай бұрын
Thank you so much. Almost watched 20+ video but could not follow along. It was to hard for me and i was looking for someone who can make it easy for me. You are a great teacher. you know your work very well. Subscribed.
@SimonSezIT
10 ай бұрын
Woohoo! Thanks for subscribing! We're thrilled that our videos are making things easier for you. Hang on tight, because there's more great content coming your way! 😊 We have lots of additional free Excel training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzitem.info/door/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZitem Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzitem.info ♥️ We appreciate your support!
@dolittlediehard1670
Жыл бұрын
❤ very good! I'm about to sit an exam and this really helped. Because i'm sure this is exactly what they expect us to be able to do. Most of the the other videos are too simple.
@rustysturgeon2160
3 жыл бұрын
So helpful! Your presentation and approach are clear and precise, loved this.....so weird to say I love something in Excel :)
@SimonSezIT
3 жыл бұрын
Thanks! That means a lot!
@harikiran2863
Жыл бұрын
This is Excellent, I wanted a specific word which starts with CVE and this LEFT/RIGHT/LEN/FIND formulas worked great, thank you so much for posting this
@mmalleshi
2 ай бұрын
Great explanation
@SimonSezIT
2 ай бұрын
Glad it was helpful! Thanks for watching 🙂
@VP-yp8ip
10 ай бұрын
This is so nicely explained. I could use these examples in my daily life. Thanks a lot.
@SimonSezIT
10 ай бұрын
You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzitem.info/door/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzitem.info/door/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZitem Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzitem.info ♥️ We appreciate your support!
@jagudaniya
6 ай бұрын
It really helped me to clear my concept, Thank you so much for great explanation. God bless you.
@SimonSezIT
6 ай бұрын
We are glad it helped. Thanks for watching :-)
@RaviSankar-nn3wx
Жыл бұрын
Thanks for teaching string functions in Excel so context would be very helpful for me..
@SimonSezIT
Жыл бұрын
You are welcome! Glad it was helpful :-)
@MrKhaled306
10 ай бұрын
This saves me lots of hours of headaches at work Thank you so much for the detailed tutorial I wast trying to extract cheq numbers from a very complicated bank statement form I hope i can implement it though 💪🏽
@SimonSezIT
10 ай бұрын
Thank you for your kind words! I'm so glad the tutorial was useful for you. It's always rewarding to know that our content is making a positive impact. We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZitem Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzitem.info ♥️ We appreciate your support!
@HK-hf9bl
Жыл бұрын
Simple to understand and very well explained. Thank you for the hard work.
@SimonSezIT
Жыл бұрын
Glad you liked it!
@UndeadGolis
2 жыл бұрын
Thank you so much, you just saved me hours of work!
@SimonSezIT
2 жыл бұрын
You are welcome! Thanks for watching ;-)
@rperea73
2 жыл бұрын
Excellent! Thanks for the help. Found what I wanted to do with a dataset which has two different delimiters in the middle. Greetings from Panamá!
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzitem.info/door/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzitem.info/door/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZitem Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzitem.info ♥️ We appreciate your support!
@JSCDofGB
5 ай бұрын
THANK YOU!!!
@SimonSezIT
5 ай бұрын
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 kzitem.info/door/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@lukasvasicek4866
10 ай бұрын
This was so useful for me! Thank you. :)
@SimonSezIT
9 ай бұрын
No problem! You're welcome. Happy to help. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzitem.info/door/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzitem.info/door/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZitem Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzitem.info ♥️ We appreciate your support!
@user-xy3lj1vw2j
4 ай бұрын
Thank you so much
@SimonSezIT
4 ай бұрын
You are very welcome 🙂 Learn more Microsoft Excel Tips and Tricks here ➡️ kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@MichaelBostrom
Жыл бұрын
Very helpful, great examples.
@gAkisoferi
24 күн бұрын
Thanks so much
@SimonSezIT
22 күн бұрын
You are very welcome! Thanks for watching 😃
@SkyRainesNW
Жыл бұрын
God bless you for this
@SimonSezIT
Жыл бұрын
Thanks! 😊 We have lots of additional free Excel training if you need it 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉 kzitem.info/door/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@mahardhykaprakasha5596
4 ай бұрын
Awesome! Really Worked!
@SimonSezIT
4 ай бұрын
Glad it was helpful. 🤩 Here are more Microsoft Excel Tips and Tricks to try on ➡️ kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@jaswanthpatnaik125
2 жыл бұрын
It works. Thank you so much
@SimonSezIT
2 жыл бұрын
Many many thanks 🙂
@Gentrone
2 жыл бұрын
Thank you very much, beautiful-voiced English-woman.
@SimonSezIT
2 жыл бұрын
You are welcome! Thanks for watching ;-)
@RohithN10
8 ай бұрын
Amazing Work!
@SimonSezIT
8 ай бұрын
Thank you so much! We really appreciate your kind words and support. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzitem.info/door/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzitem.info/door/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZitem Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzitem.info ♥️ We appreciate your support!
@ben529
2 жыл бұрын
Very helpful, and a lovely accent.
@SimonSezIT
2 жыл бұрын
Thank you Ben! 😃
@tonykomery7991
9 ай бұрын
that was a great video, thank you so much.
@SimonSezIT
9 ай бұрын
Hey, thanks a bunch for watching and for the awesome feedback! I appreciate it! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzitem.info/door/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzitem.info/door/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZitem Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzitem.info ♥️ We appreciate your support!
@christiangonzales9851
2 жыл бұрын
You've got a subscriber here. Thanks for the lesson
@SimonSezIT
2 жыл бұрын
Thanks for the sub!
@leftindependent
7 ай бұрын
Great job! Very useful :)
@SimonSezIT
7 ай бұрын
Wow, thanks! Glad it was useful. 🤩 🚀 Level up your Excel skills with free training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@hmabboud
Жыл бұрын
Finally! Thank you!
@SimonSezIT
Жыл бұрын
You bet!
@NihalAhamed370
2 жыл бұрын
you are legend and earned a SUB thankyou.
@SimonSezIT
2 жыл бұрын
Wow, thanks!
@janicefranklin8225
2 жыл бұрын
Excellent video
@siriwatpongpattananukul2480
2 жыл бұрын
Very helpful !! Thanks.
@SimonSezIT
2 жыл бұрын
Glad it was helpful!
@isaacmazack546
2 жыл бұрын
Thank you! SOOOO Helpful!!!!!
@Maheshc27
5 ай бұрын
So, we don't have to introduce in speaking test? Will the test start directly with the images as you shown above?
@DSeisun1
2 жыл бұрын
Excellent and easy to follow. Thank you.
@SimonSezIT
2 жыл бұрын
Glad you enjoyed it!
@c.mosinghi2281
2 жыл бұрын
I must say i really enjoy the voice more than even the tutorial ....hahaha
@SimonSezIT
2 жыл бұрын
We'll let Deb know. :)
@user-qd4tk7dk4r
8 ай бұрын
Hi! When you sort a highlighted row, how can excel scroll to that row, so you do not have to look for that row yourself?
@pedrodouradocampos9022
2 жыл бұрын
Aewsome!
@er.ajaykumar6978
Жыл бұрын
Amazing ❤
@abdelwahabdessouky292
Жыл бұрын
Super stupid friendly than you so much for the explanation
@ankuragarwal3518
Жыл бұрын
Awesome...
@SimonSezIT
Жыл бұрын
Thanks 🤗
@jroobz
3 жыл бұрын
thanks for this! really helped
@SimonSezIT
3 жыл бұрын
No problem!
@arindambhattacharya8127
Жыл бұрын
You chose the easy one - please show how to do the same from the first column i.e. Name and second name
@Chanrith.C
Жыл бұрын
Could you share this Excel file for practice? Thanks.
@IshanDuttagglblord
2 жыл бұрын
It was indeed amazing
@chris-zu6sf
2 жыл бұрын
Can you make a video that will return a partial string such as 'Ft G Meade, MD' from a text string 'Fort George Meade, MD'? Both are sourced from different tables.
@justin98tx
2 жыл бұрын
thank you!!!!
@SimonSezIT
2 жыл бұрын
You are welcome! 😊
@kaylaperez3407
2 жыл бұрын
Bless you!
@SimonSezIT
2 жыл бұрын
And you too!
@etrader4690
2 жыл бұрын
This is very help full video but I am stuck with cell phone numbers extractions example I want to extract repeated numbers from a cell phone that will show and not repeating numbers could you help me that
@amandeepsinghbassi1600
Жыл бұрын
HOW TO LOOKUP(OR COMPARE MATCH) ONLY EXACT LAST 4 DIGITS OF MASKED ID_NO WITH COMPLETE ID_NUMBER AND SEARCH FROM RANGE AND POPULATE DATA OF COMPLETE Id_Number IN OTHER COLUMN.. I MEAN TO SAY CAN WE USE MATCH WITH RIGHT FUNCTION IN EXCEL
@jasonhays8644
3 жыл бұрын
Is it possible to find multiple strings of data with the MID function in the same cell? I have data with buried email addresses in it, but there's a lot of garbage data in between. I am able to use the MID function to extract the first instance of the email, but none of the subsequent emails in the same cell.
@duncand9648
4 ай бұрын
Genius
@SimonSezIT
4 ай бұрын
Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@arvindmishra7364
2 жыл бұрын
What if there are multiple occurances of charactors and I want to extract nth charactor between nth charactor combination.
@nallyvaico
2 жыл бұрын
Excellent. But I have another problem: I have 3-5 text variables that I am looking for in a long text... How can I extract those variables to a separate column? Of course, I could do exactly THIS exercise, but isn't there a workaround? Would FIND/SEARCH etc functions do any good?
@hashimjarrar9495
3 жыл бұрын
Wonderfull
@SimonSezIT
3 жыл бұрын
Much appreciate Hashim!
@JR.JimRoss
2 жыл бұрын
Awesome
@tamluk-sis3238
Жыл бұрын
Is there any way to check that there exist any number within the first 3 characters in the following example: A5C-123-001???
@arosete1979
Жыл бұрын
what if the symbol is space?
@user-eh4bj8ek6q
9 ай бұрын
How do you combine 2 results together, though? + , "" do not work..
@joseluizcarvalho2236
7 ай бұрын
You can use “concat” function
@subaidayousuf6716
6 ай бұрын
Use & function
@narutouzamaki8573
8 ай бұрын
Why my excel doesn't have textsplit, text before and text after function I'm using latest 2021 version. can anyone please help me.
@TechVHD
2 жыл бұрын
How do i do the part at 12:18 but instead of finding everything before .com, what I am looking for is everything before an underscore "_", but I am also looking for everything after another underscore in the beginning, As in the text has two underscores and I am looking for the word in between both underscores
@shahidsdenmarkdiary...2188
Жыл бұрын
How to extract text from two different sheets and return output to third sheet with some condition?
@shahidsdenmarkdiary...2188
Жыл бұрын
If, sheet 1 has John in B2 and sheet 2 has Jacob in B2, i want output of sheet1B2 and sheet2B2, if sheet2 B2 has Jacob, then ignore or blank
@billybobbarker3175
6 ай бұрын
Ok. So after extracting what is needed, how do I combine the extractions into a different cell? Example; I extract “ABC” from one cell, then I extract “BobbyJoe” from another cell, and what I want for result in a different cell is “ABC BobbyJoe” How do I do that?
@CHME9ME9
5 ай бұрын
Textjoin , concat , concatenate, these formulas is perfect for you need , i recommend the first one
@skatlag
2 жыл бұрын
What should I do if I want to copy gotten resutls, but can't do it becuase it just copies the formula?
@hairlovenyc2849
2 жыл бұрын
How can i extract a SKU from something like this: SKU: HAR-SHO-WEL-3.5 ( Hair Product, Shampoo, Wella, 3.5) Please help!!!!!
@SorinNitzoy
3 жыл бұрын
Lovely!
@ericzakaib7823
2 жыл бұрын
Hello, can you trim front and end of a character cell? I have been able to do it in 2 steps but not as 1 step - Thank you
@SimonSezIT
2 жыл бұрын
You can combine multiple functions within one formula to get what you need.
@wenqianwang5292
3 жыл бұрын
Thanks a lot for your video. Can I ask one question: if my text is "aaaaa_bbb_cccc_dddd", how can I extract 'bbb'??
@stopdrinkingleftskoolaid6510
3 жыл бұрын
=MID(A1,FIND("b",A1),3)
@biancaandreeas
2 жыл бұрын
Hello! What if i have a column with different products and i need to extract only the brand of the products? So basically the number of characters i eant to extract is different. What formula do i use so excel can calculate automatically for the rest if i use drag down after i use the formula for the first product?
@windybacsa3685
2 жыл бұрын
Is the brand separated by a space? If it is, then I guess you could still do the same formula in the video but your FIND/SEARCH text string will be " "
@helmanfrow
2 жыл бұрын
The easy way to do all these is to switch to Google Sheets and use the SPLIT() function 😉.
@SimonSezIT
2 жыл бұрын
Great suggestion! 😊
@chaz9808
2 жыл бұрын
yeah but what if the cell contains numbers instead of text?
@SimonSezIT
2 жыл бұрын
These functions work with both number and text strings, you just need to adjust your formulas (which character to find/search or character length) to accommodate what your data set and what you are trying to extract from it.
@tutsecret499
Жыл бұрын
How do I deduct letters, example: Alameda, I want to cut everything except A, from Alameda it will be A, so when I merge the data, the Directory in word will show Drop Cap as A, next line Alameda, and so forth, if I don't have this in excel extra column this deduction, the word document will show A(the drop cap) and repeat alameda. I don't want this repetition. I want the drop cap exclusively alone first line, and 2nd paragraph the Alameda County etc. If I have the data in Access, I would not have this problem that has a feature to deduct the Heading letters to make the Drop Cap. How do I avoid repetition from excel data when I merging in word. Example: Alameda has many depts, etc. If Alameda has 5 depts, it will repeat in the word document 5 times the Alameda heading. How it can display only one time Alameda and it's depts, and next county like Alpino should do same no repetition.
@mstipich1
2 жыл бұрын
Here just for the accent.
@SimonSezIT
2 жыл бұрын
Debs definitely sounds lovely.
@mstipich1
2 жыл бұрын
@@SimonSezIT 👌
@hechosrandom
Жыл бұрын
crackkkkkkkkkkkkkkkkkkkkkkkkkkk
@arulkavi4931
Жыл бұрын
To extractmail domain why not we USE RIGHT)( LEN(B3)-FIND (" @"'B3))
@Arrichftw2
Жыл бұрын
I love you
@FathomMinistries
Жыл бұрын
Thanks!
@SimonSezIT
Жыл бұрын
Many thanks for sharing your appreciation ❤️
@josslinecorreia26
3 жыл бұрын
Thank you!
@SimonSezIT
3 жыл бұрын
You bet!
@34kooky
10 ай бұрын
Thank you ! Very helpful!
@SimonSezIT
10 ай бұрын
You're welcome! We're thrilled to know that you found our video helpful. 😉 We have additional free Excel training if you need it 👉 kzitem.info/door/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzitem.info/door/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzitem.info/door/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZitem Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzitem.info ♥️ We appreciate your support!
Пікірлер: 141