the following may or may not be a simple formula but i cannot seem to solve this problem without writing a drawn out formula. Here is obstacle I am encountering...i have the following information...
a b
1 hello h1
2 how h1
3 are h2
i would like a formula that finds all "h1" in column b and puts all text in column a (in this case "hello" and "how") into one cell, so the cell would look like "hellohow" (you would also need to add a space or comma or both to the cell.
thanks in advance.
Bookmarks