Send to a Friend
I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.
Asked by ETpro (34605)
February 16th, 2010
How can I write a formula to parse a column in Excel and write a list containing each cell that has a specific string as part of its content?
For instance, say Column A is the html name of pages on a web site. I want to generate a new column with every html name that has the string “string” somewhere within it. I’m sure it can be done, but haven’t a clue how.
Using Fluther
or