On Jan 20, 11:08*am, Rod wrote:
Hi

I have the data as shown below

123456.tif
123-456-1.tif
123456-1.tif
12345.tif
123456tif
123456a.tif

I need the first 6 numbers in column B
Please help me

Thanks in advance.

=left("Whatever cell you are looking at,6)*1 Soemtimes you ahve to
multiply times 1 so that it turns it into a number.