Hi,

I want to collect the cells which begins with the same number or specified text in one column. Those cells are located in different columns in every row. Sample text is attached. I tried several solutions, and may be I'm doing it wrong in mac version (excel 2011), as I'm new to even keyboards in mac.

I appreciate your help.

Atakan sample.xlsx