We have additional free Microsoft Excel training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & How to Create a Dashboard in Excel here 👉th-cam.com/play/PLzj7TwUeMQ3g1WJPlf-mojgdR3gN-JWIz.html 🔥Check out our FREE 300+ hour training course playlist here ➡ th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
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.
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
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
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.
❤ 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.
You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so much! We really appreciate your kind words and support. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
You're welcome! We're thrilled to know that you found our video helpful. 😉 We have additional free Excel training if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
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.
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 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Hey, thanks a bunch for watching and for the awesome feedback! I appreciate it! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Wow, thanks! Glad it was useful. 🤩 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
No problem! You're welcome. Happy to help. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Thanks! 😊 We have lots of additional free Excel training if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
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 💪🏽
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 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
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?
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.
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.
Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
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
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
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
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?
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 " "
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?
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.
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.
We have additional free Microsoft Excel training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & How to Create a Dashboard in Excel here 👉th-cam.com/play/PLzj7TwUeMQ3g1WJPlf-mojgdR3gN-JWIz.html
🔥Check out our FREE 300+ hour training course playlist here ➡
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
I really like the incremental approach this teacher is teaching, very helpful. Was able to understand and do even some complex strings.
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.
Wow, thanks! So glad you enjoyed it 😊 Additional Excel tips here if you need them -> th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
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
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
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.
Thank you Norman, we appreciate your comments!
❤ 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.
So helpful! Your presentation and approach are clear and precise, loved this.....so weird to say I love something in Excel :)
Thanks! That means a lot!
Best step by step progression in an excel fomular I've ever seen.
Glad you liked it!
Thank you! SOOOO Helpful!!!!!
Thank you. Nice Explanation!
Very helpful, great examples.
Excellent and easy to follow. Thank you.
Glad you enjoyed it!
Simple to understand and very well explained. Thank you for the hard work.
Glad you liked it!
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.
You are very welcome! Glad it was helpful. 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Excellent video
Awesome! Really Worked!
Glad it was helpful. 🤩 Here are more Microsoft Excel Tips and Tricks to try on ➡️
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Amazing Work!
Thank you so much! We really appreciate your kind words and support. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Very helpful !!
Thanks.
Glad it was helpful!
Thank you ! Very helpful!
You're welcome! We're thrilled to know that you found our video helpful. 😉
We have additional free Excel training if you need it 👉
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
thanks for this! really helped
No problem!
Thank you so much, you just saved me hours of work!
You are welcome! Thanks for watching ;-)
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.
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 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
It was indeed amazing
This is so nicely explained. I could use these examples in my daily life. Thanks a lot.
You are very welcome! Glad it was helpful. 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
It really helped me to clear my concept, Thank you so much for great explanation. God bless you.
We are glad it helped. Thanks for watching :-)
Thank you!
You bet!
Thanks for teaching string functions in Excel so context would be very helpful for me..
You are welcome! Glad it was helpful :-)
Finally! Thank you!
You bet!
that was a great video, thank you so much.
Hey, thanks a bunch for watching and for the awesome feedback! I appreciate it! 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
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á!
You're welcome Roger Perea from Panamá! :-)
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Great job! Very useful :)
Wow, thanks! Glad it was useful. 🤩
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
THANK YOU!!!
You are very welcome! Thanks for watching 🙂
🔥Check out our FREE 400+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Amazing ❤
Great explanation
Glad it was helpful! Thanks for watching 🙂
Thank you so much
You are very welcome 🙂 Learn more Microsoft Excel Tips and Tricks here ➡️ th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
This was so useful for me! Thank you. :)
No problem! You're welcome. Happy to help. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
this video is so easy to understand. Great
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
It works. Thank you so much
Many many thanks 🙂
Thank you very much, beautiful-voiced English-woman.
You are welcome! Thanks for watching ;-)
Lovely!
God bless you for this
Thanks! 😊 We have lots of additional free Excel training if you need it 👉
th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Bless you!
And you too!
Thanks!
Many thanks for sharing your appreciation ❤️
Very helpful, and a lovely accent.
Thank you Ben! 😃
Aewsome!
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 💪🏽
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 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
You've got a subscriber here. Thanks for the lesson
Thanks for the sub!
thank you!!!!
You are welcome! 😊
you are legend and earned a SUB thankyou.
Wow, thanks!
Awesome...
Thanks 🤗
Awesome
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?
Wonderfull
Much appreciate Hashim!
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.
I must say i really enjoy the voice more than even the tutorial ....hahaha
We'll let Deb know. :)
Super stupid friendly than you so much for the explanation
So, we don't have to introduce in speaking test? Will the test start directly with the images as you shown above?
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.
I love you
Genius
Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Could you share this Excel file for practice?
Thanks.
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?
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
What if there are multiple occurances of charactors and I want to extract nth charactor between nth charactor combination.
Is there any way to check that there exist any number within the first 3 characters in the following example: A5C-123-001???
What should I do if I want to copy gotten resutls, but can't do it becuase it just copies the formula?
You chose the easy one - please show how to do the same from the first column i.e. Name and second name
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
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
Thanks a lot for your video. Can I ask one question: if my text is "aaaaa_bbb_cccc_dddd", how can I extract 'bbb'??
=MID(A1,FIND("b",A1),3)
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
You can combine multiple functions within one formula to get what you need.
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?
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 " "
How can i extract a SKU from something like this: SKU: HAR-SHO-WEL-3.5 ( Hair Product, Shampoo, Wella, 3.5) Please help!!!!!
How to extract text from two different sheets and return output to third sheet with some condition?
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
what if the symbol is space?
Why my excel doesn't have textsplit, text before and text after function I'm using latest 2021 version. can anyone please help me.
How do you combine 2 results together, though? + , "" do not work..
You can use “concat” function
Use & function
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?
Textjoin , concat , concatenate, these formulas is perfect for you need , i recommend the first one
The easy way to do all these is to switch to Google Sheets and use the SPLIT() function 😉.
Great suggestion! 😊
yeah but what if the cell contains numbers instead of text?
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.
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.
crackkkkkkkkkkkkkkkkkkkkkkkkkkk
Here just for the accent.
Debs definitely sounds lovely.
@@SimonSezIT 👌
To extractmail domain why not we USE RIGHT)( LEN(B3)-FIND (" @"'B3))