Extract Text Between Two Characters in Excel

Extract text between two characters in a cell. This video looks at how to extract text between two forward slashes (/) in Excel. It will not be straightforward and multiple functions are used together to achieve it.

The LEFT function is used to extract a specified number of characters from the start of text. And the MID function is used to pass the relevant text to it. FIND functions are used to locate the two characters for the formula.

=LEFT(MID(B3,FIND("/",B3)+1,LEN(B3)),FIND("/",MID(B3,FIND("/",B3)+1,LEN(B3)))-1)

The formula above can be adapted to your needs. The characters may be different but the process remains the same.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[richiefarrell]

Thanks for putting the formula in the description, you're a good man!

[bulljr]

Great example of something we all need to do from time to time that is extremely difficult to explain. Thanks for taking the time to put this together and share.

[YhelloWish]

This guy is LEGENDARY! Thank you so much!

[JakeS]

Very helpful explanation! I've honestly never seen a better walk through for an Excel formula. Just helped me solve an issue with a project I've been working on! Thank you!!

[douglasbrown]

Alan - I have been a fan of yours for several years now and truly appreciate your Excel expertise. This video about extracting text between two characters has been just want I need for my first project in my new job. Thank you so very much! I am sure this formula can be modified if you encounter a text string in a cell where you have to extract some text that falls between two different characters (e.g. a "/" and a "_" ). Thanks a million again!

[annezach]

This is exactly what I needed. Thank you for this!

[dj]

THANK YOU SO MUCH it took me over an hour to find this. You are amazing.

[FranciscoRodriguez]

I never comment on youtube videos but I'll do so right now just to express my sincere gratitude for this incredibly helpful video.

[adamdiestelkamp]

Perfect, I was trying to extract the domain from a list of email address, this worked wonderfully!

[MrZener]

Man you are a life saver, I used to extract coordinates from Google Maps URL !

[markbell]

Perfect: no mumbo-jumbo, no what the hell?  You said it and showed it and I did. Beauty!!  Cheers, Mark

[LM-tzjs]

Thank you so much! I am not sure if I'll be able to create it myself in the future, but I was able to create a formula by following your instruction step by step. I'll be able to use this formula for my future entries!! It saves me a lot of times.

[KarimVakil]

Thanks buddy, you saved my labor of hours and hours !

[TheAjee]

Great tutorial! This helped me tremendously.

[andmust]

Thanks man this is 2018 and your video helped me a lot

[plavali_znaem]

genius example, exactly what I was looking for. Fantastic expert!

[rawsmoke]

I was looking for +2 hours, genius man thanks !

[michalroesler]

Epic video and extraordinary Excel skills. Kudos to Computergaga.

[willivia]

Thank you so much! You saved me a day's worth of work!! YOU ROCK

[Brianrobillard]

I was looking for so long to find this. Good form!