Finding numbers in a cell

[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

 

[Frank Kabel]

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')

 

[Andy B]

Frank

Instead of MIDL, I think you mean MID

Andy.

 

[Frank Kabel]

Yes