Hello,

I keep getting a value error on one of my formula cells. I'm obviously
using the wrong data type. Can someone please point out where it is I'm
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 characters
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 thanks


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=536723

Hi,

One way would be

=MID(A1,3,1024)

Regards,
Bondi