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