I would copy the entire column over to the next column and then use the
feature of the free add-in called ASAP Utilities, to delete all the
alpha-characters in that column.......leaving only the numbers........the
add-in is available at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3



" wrote:

Hi,

Is there a way to extract the numbers, remove them and place them in an
adjacent column from the cells in the example below? The LEFT function
does not do the entire trick, since the amount of numbers differs per
cell and I still need to delete the number in the original cell.

1bla
1.1blabla
1.1.1blablabla
1.1.1.1blablablabla

Thanks