Send to a Friend

ETpro's avatar

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 (34605points) 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

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.