Finding numbers in a cell

  • Thread starter Thread starter Andyb_140
  • Start date Start date
A

Andyb_140

I am trying to sort a column of data. Some cells contain just alpha dat
and some columns contain alpha numerical data. I wish to find only th
cells that contain alpha data i.e cells with no numbers in
 
Hi
one way:
- add a helper column (lets say column B)
- enter the following array formula (entered with CTRL+SHIFT+ENTER) in
B1:
=IF(SUM(--ISNUMBER(--MIDL(A1,ROW(INDIRECT("1:1024")),1)))>0,"","X")
and copy down.
- use this column for sorting (all rows with 'X')
 
Back
Top