value error

M

Max_power

Hello,

I keep getting a value error on one of my formula cells. I'm obviousl
using the wrong data type. Can someone please point out where it is I'
going wrong.

I have a column of data like
wr53453453
tr54353453
............

I'm trying to write a formula where I take away the first 2 character
of the data in each cell.
My formula is

=A1-LEFT(A1,2

I must have incompatable data types or am I just way off the mark?

Many thank
 
Top