Hi!
I need a formula that can search for 445 in a column and return only numbers that starts with 445
E.g.
"Raw" Data
1445116
1445116
22126E+12
221653E+12
221629E+12
221161E+12
445502E+14
445502E+14
Output (after formula)
445502E+14
445502E+14
Since I am not that good in VBA I need a straight forward formula
Thanks
I need a formula that can search for 445 in a column and return only numbers that starts with 445
E.g.
"Raw" Data
1445116
1445116
22126E+12
221653E+12
221629E+12
221161E+12
445502E+14
445502E+14
Output (after formula)
445502E+14
445502E+14
Since I am not that good in VBA I need a straight forward formula
Thanks