How can I extract characters from inside a cell?

E

Eric

I need to extract portions of cell contents (i.e. B109912345 - i need the
1099 out of this info) and prot it to the cell to the right (next column)
 
P

Pete_UK

If it is always going to be those characters (i.e. from the 2nd to the
5th inclusive), then use this:

=MID(A1,2,4)

If you need it to be numeric, then just multiply by 1.

Hope this helps.

Pete
 
E

Eric

Thanks for the tip, but what if i have an entire column to extract data from?
is there a way to automate this task?
 
D

David Biddulph

=MID(A1,2,4) if you want it as text or =--MID(A1,2,4) if you want it as a
number.
 
Top