BeenieBeensta
New Member
- Joined
- Nov 27, 2018
- Messages
- 1
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
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
