Help

[BeenieBeensta]

Hi there,
Been using excel 2010.
When I extract numbers and text from one colum by using =left(A1,H6)
Once I have the data it does not allow me to calculate or format.
I have tried to copy and special paste but no luck.
After I tried special paste I tried to add the numbers I extracted and they all turn to zero.

Hope I can get help

 

[gaz_chops]

Welcome to MrExcel,

Try

=left(A1,H6)+0