Sort Cells Containing Numbers

[Perodin]

I have a list of raw data and would like to pull headings from the entries. I am currently using =IF(ISNUMBER(VALUE(LEFT(B1,4))),"",B1) to pull any lines that contain text in the first 4 characters and would like to add a function to eliminate any results containing numbers to get me the results i want.

My data appears as so (abridged - there are many more lines that start with numbers)
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]1[/TD]
[TD]Bearings & Bushings[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4607 Ball bearings (5x11x4mm) (8) ..................................................... $24.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2728 Ball bearings (5x8x2.5mm) (2) ..................................................... $8.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Body & Accessories[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]38mm (2), 25mm (2), 6.5mm (2)/ body post extensions (2)/[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]hardware ........................................................................................ $6.00[/TD]
[/TR]
</tbody>[/TABLE]

Currently rows 1,4,5, and 6 are being pulled to column C by my formula and all lines I don't want contain a number of some type. I would like to only be pulling lines 1 and 4, and my headings never have numbers. I am also open to other suggestions or approaches.

 

[kvsrinivasamurthy]

If Data range is A1:B6, Formula In D1, then drag down.

=IF(SUMPRODUCT(--(ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},B1,1))))>0,"",B1)

 

[pgc01]

Hi

Similar to kvsrinivasamurthy's formula:

=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},B1)),"",B1)

 

[Perodin]

Both of these got it done, Thank You

 

[pgc01]

I'm glad we were able to help. Thanks for the feedback.