Alpha with numeric and numeric only numbers in a column
Tik Num Num Only
rc65789876 0
dl987898
768765544 987898
234876
234876
It returned above. It appears it only did every other line.
"Mike H" wrote:
Hi,
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0 123456789")),ROW($1:$10000))))
All 1 line drag down as required
Mike
"rciolkosz" wrote:
I have a column with 2 alpha letters leading numbers and also numbers only in
the same column. I want to put all records in a new column without any
alpha. How would I do that?
Example:
ar3456789
bt56789
234567
78901234
etc.
|