How to Extract Part of Text String from an Excel Cell

In this tutorial, we teach you how to use this handy Excel function.

This useful tool can extract text using the text functions, LEFT, MID and RIGHT tools and more complex extraction of text using the SEARCH or FIND functions.

Not only is this a great time-saving function, but it also makes extracting information from data sets easy!

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[SimonSezIT]

🔥Check out our FREE 300+ hour training course playlist here ➡

[jot]

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

[hstevenadams]

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.

[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

[rustysturgeon]

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

[harikiran]

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

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

[dolittlediehard]

❤ 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.

[DSeisun]

Excellent and easy to follow. Thank you.

[HK-hfbl]

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

[rperea]

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

[Manohar.K]

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.

[UndeadGolis]

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

[jagudaniya]

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

[jamlecknjagi]

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

[RaviSankar-nnwx]

Thanks for teaching string functions in Excel so context would be very helpful for me..

[VP-ypip]

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

[kruwomb]

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.

[lukasvasicek]

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

[tonykomery]

that was a great video, thank you so much.