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