I have a very large spreadsheet with html in each cell in column 1. There are multiple text strings (potentially 3 to 20) within the html in each cell. Each string is preceded with HREF= and the string has a " before and after the string.

I want to have a macro that searches each cell in column 1 and finds the HREF= (multiple instances...as few as 3 to as many as 20) and extracts the string between the double quotes (i.e. "string") and writes them to the first column in worksheet 2 in the workbook.

I am not a programmer...but have spent a few days trying to find a macro or use the MID or FIND function to do this with minimal success. Can someone please help?

Thanks!