How do I extract a portion of a string into an adjacent cell?

**tura910** · 03-25-2012, 10:00 PM

Hello! Here is the basic situation, I have one cell with text and a hyperlink. I found a macro to run that extracted the hyperlink into the cell in the next column. Now what I would like to do is further extract just a portion of the hyperlink into the next cell. Does any one have an idea how I might do that? The first 3 characters of the portion I would like extracted are always the same, it is always a length of 10 characters, and it is always between two slashes, for example /ABC1234567/. Thanks if you can help!!

**DGagnon** · 03-25-2012, 10:34 PM

Hi there, im currently on a PC without excel so i cannot test, but you shoudl be able to do this with something like this

=MID(A1,FIND("/ABC",A1)+1,10)

**DGagnon** · 03-25-2012, 10:51 PM

back on an Excel enabled PC, the above had an error in the FIND function, i got the paramaters mixed up the bellow should work for you

=MID(A1,FIND("/ABC",A1)+1,10)

if you want to include the /'s you can use this.

=MID(A1,FIND("/ABC",A1),12)

**tura910** · 03-26-2012, 04:08 AM

Thank you, thank you!! That worked exactly how I needed it to! You have saved me days worth of time doing it manually.

I actually tried the first formula you gave before I saw the corrected one, and noticed the two things in FIND were switched. In my particular case, and if anyone else is reading this with the same question, the formula works the same without the +1 if the / is removed from the quotes. Thanks again for your help, DGagnon! <3

Same results in my case:
=MID(A1,FIND("/ABC",A1)+1,10)
=MID(A1,FIND("ABC",A1),10)