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)

1	Bearings & Bushings
2	4607 Ball bearings (5x11x4mm) (8) ..................................................... $24.00
3	2728 Ball bearings (5x8x2.5mm) (2) ..................................................... $8.00
4	Body & Accessories
5	38mm (2), 25mm (2), 6.5mm (2)/ body post extensions (2)/
6	hardware ........................................................................................ $6.00

<tbody>
</tbody>

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.