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