How to Extract Part of Text String from an Excel Cell

[@SimonSezIT]

We have additional free Microsoft Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & How to Create a Dashboard in Excel here 👉kzbin.info/aero/PLzj7TwUeMQ3g1WJPlf-mojgdR3gN-JWIz 🔥Check out our FREE 300+ hour training course playlist here ➡ kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@hsteven1110]

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 -> kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@jamlecknjagi842]

Best step by step progression in an excel fomular I've ever seen.

[@SimonSezIT]

Glad you liked it!

[@JonnieLingo]

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]

Thank you Norman, we appreciate your comments!

[@rustysturgeon2160]

So helpful! Your presentation and approach are clear and precise, loved this.....so weird to say I love something in Excel :)

[@SimonSezIT]

Thanks! That means a lot!

[@april147]

It was super helpful! Thank you so much!

[@SimonSezIT]

Wow, thanks! Glad it was helpful. 🤩

[@UndeadGolis]

Thank you so much, you just saved me hours of work!

[@SimonSezIT]

You are welcome! Thanks for watching ;-)

[@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

[@HK-hf9bl]

Simple to understand and very well explained. Thank you for the hard work.

[@SimonSezIT]

Glad you liked it!

[@rperea73]

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á!

[@SimonSezIT]

You're welcome Roger Perea from Panamá! :-)

[@VP-yp8ip]

This is so nicely explained. I could use these examples in my daily life. Thanks a lot.

[@SimonSezIT]

You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@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 :-)

[@jagudaniya]

It really helped me to clear my concept, Thank you so much for great explanation. God bless you.

[@SimonSezIT]

We are glad it helped. Thanks for watching :-)

[@MrKhaled306]

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]

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 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@mmalleshi]

Great explanation

[@SimonSezIT]

Glad it was helpful! Thanks for watching 🙂

[@melaniezhao4875]

this video is so easy to understand. Great

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@lukasvasicek4866]

This was so useful for me! Thank you. :)

[@SimonSezIT]

No problem! You're welcome. Happy to help. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@MichaelBostrom]

Very helpful, great examples.

[@Maheshc27]

So, we don't have to introduce in speaking test? Will the test start directly with the images as you shown above?

[@christiangonzales9851]

You've got a subscriber here. Thanks for the lesson

[@SimonSezIT]

Thanks for the sub!

[@ben529]

Very helpful, and a lovely accent.

[@SimonSezIT]

Thank you Ben! 😃

[@Gentrone]

Thank you very much, beautiful-voiced English-woman.

[@SimonSezIT]

You are welcome! Thanks for watching ;-)

[@mahardhykaprakasha5596]

Awesome! Really Worked!

[@SimonSezIT]

Glad it was helpful. 🤩 Here are more Microsoft Excel Tips and Tricks to try on ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@JSCDofGB]

THANK YOU!!!

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@isaacmazack546]

Thank you! SOOOO Helpful!!!!!

[@NihalAhamed370]

you are legend and earned a SUB thankyou.

[@SimonSezIT]

Wow, thanks!

[@RohithN10]

Amazing Work!

[@SimonSezIT]

Thank you so much! We really appreciate your kind words and support. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@jaswanthpatnaik125]

It works. Thank you so much

[@SimonSezIT]

Many many thanks 🙂

[@AdnanMurtaza-d8m]

Thank you so much

[@SimonSezIT]

You are very welcome 🙂 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@tonykomery7991]

that was a great video, thank you so much.

[@SimonSezIT]

Hey, thanks a bunch for watching and for the awesome feedback! I appreciate it! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@SkyRainesNW]

God bless you for this

[@SimonSezIT]

Thanks! 😊 We have lots of additional free Excel training if you need it 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@gAkisoferi]

Thanks so much

[@SimonSezIT]

You are very welcome! Thanks for watching 😃

[@Chanrith.C]

Could you share this Excel file for practice? Thanks.

[@etrader4690]

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

[@chris-zu6sf]

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.

[@jasonhays8644]

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.

[@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

[@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???

[@c.mosinghi2281]

I must say i really enjoy the voice more than even the tutorial ....hahaha

[@SimonSezIT]

We'll let Deb know. :)

[@arvindmishra7364]

What if there are multiple occurances of charactors and I want to extract nth charactor between nth charactor combination.

[@jroobz]

thanks for this! really helped

[@SimonSezIT]

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

[@IshanDuttagglblord]

It was indeed amazing

[@er.ajaykumar6978]

Amazing ❤

[@skatlag]

What should I do if I want to copy gotten resutls, but can't do it becuase it just copies the formula?

[@jot2000]

I really like the incremental approach this teacher is teaching, very helpful. Was able to understand and do even some complex strings.

[@arosete1979]

what if the symbol is space?

[@abdelwahabdessouky292]

Super stupid friendly than you so much for the explanation

[@MatthewWatts-e3j]

How do you combine 2 results together, though? + , "" do not work..

[@joseluizcarvalho2236]

You can use “concat” function

[@subaidayousuf6716]

Use & function

[@hairlovenyc2849]

How can i extract a SKU from something like this: SKU: HAR-SHO-WEL-3.5 ( Hair Product, Shampoo, Wella, 3.5) Please help!!!!!

[@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

[@ankuragarwal3518]

Awesome...

[@SimonSezIT]

Thanks 🤗

[@wenqianwang5292]

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]

=MID(A1,FIND("b",A1),3)

[@ericzakaib7823]

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]

You can combine multiple functions within one formula to get what you need.

[@SorinNitzoy]

Lovely!

[@billybobbarker3175]

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]

Textjoin , concat , concatenate, these formulas is perfect for you need , i recommend the first one

[@hashimjarrar9495]

Wonderfull

[@SimonSezIT]

Much appreciate Hashim!

[@duncand9648]

Genius

[@SimonSezIT]

Wow, thanks a lot 😊 We have lots of additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@chaz9808]

yeah but what if the cell contains numbers instead of text?

[@SimonSezIT]

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.

[@helmanfrow]

The easy way to do all these is to switch to Google Sheets and use the SPLIT() function 😉.

[@SimonSezIT]

Great suggestion! 😊

[@hechosrandom]

crackkkkkkkkkkkkkkkkkkkkkkkkkkk

[@mstipich1]

Here just for the accent.

[@SimonSezIT]

Debs definitely sounds lovely.

[@mstipich1]

@@SimonSezIT 👌

[@Arrichftw2]

I love you

[@FathomMinistries]

Thanks!

[@SimonSezIT]

Many thanks for sharing your appreciation ❤️

[@emanuelninayupanqui9759]

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@narutouzamaki8573]

Why my excel doesn't have textsplit, text before and text after function I'm using latest 2021 version. can anyone please help me.

[@IsidorosParlamas-h9p]

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?

[@TechVHD]

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

[@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.

[@nallyvaico]

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?

[@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

[@pedrodouradocampos9022]

Aewsome!

[@rajesha7176]

Thank you. Nice Explanation!

[@ZaraHaynes-w8v]

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]

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 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@Manohar.K1999]

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]

You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@janicefranklin8225]

Excellent video

[@JR.JimRoss]

Awesome

[@biancaandreeas]

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]

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 " "

[@leftindependent]

Great job! Very useful :)

[@SimonSezIT]

Wow, thanks! Glad it was useful. 🤩 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@siriwatpongpattananukul2480]

Very helpful !! Thanks.

[@SimonSezIT]

Glad it was helpful!

[@34kooky]

Thank you ! Very helpful!

[@SimonSezIT]

You're welcome! We're thrilled to know that you found our video helpful. 😉 We have additional free Excel training if you need it 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@hmabboud]

Finally! Thank you!

[@SimonSezIT]

You bet!

[@DSeisun1]

Excellent and easy to follow. Thank you.

[@SimonSezIT]

Glad you enjoyed it!

[@justin98tx]

thank you!!!!

[@SimonSezIT]

You are welcome! 😊

[@kaylaperez3407]

Bless you!

[@SimonSezIT]

And you too!

[@josslinecorreia26]

Thank you!

[@SimonSezIT]

You bet!

[@arulkavi4931]

To extractmail domain why not we USE RIGHT)( LEN(B3)-FIND (" @"'B3))