I get a row of cells containing some text. Let's say they are names.
<tbody>
</tbody>
With an Excel formula I need to get the whole content of the cell that contain a given word. For example, if I get "Ann", I should be able to return "Alice Ann Grey".
Any suggestions would be greatly appreciated. Thank you.
Mary Jane White | John Robert Black | Susan Lou Brown | Roger Green | Alice Ann Grey | Peter Red |
<tbody>
</tbody>
With an Excel formula I need to get the whole content of the cell that contain a given word. For example, if I get "Ann", I should be able to return "Alice Ann Grey".
Any suggestions would be greatly appreciated. Thank you.