How to extract the 5 first digits starting from the second digit from the left.

[zicitroj]

Hi all,

I am using Excel 2007. I have a column with each cell containing data in the following form: C10711 - Manufacture of bread (with or without pastry).

I need to extract only the figures into another column. Relating to the above example, I need to extract only 107111.
​

Anyone can help?

regards,
Ali

 

[JuanPa]

Hi, Ali.

Why don't you try this:

=MID(A1,2,5)

A1: The cell where the data is;
2: the position to start stracting from;
5: how many characters you need to stract.

Regards,

Juan Pablo

 

[doofusboy]

=RIGHT(LEFT(A1,6),5) assuming your data is in cell A1

 

[zicitroj]

Thanks guys! It worked a treat!