Formula to remove a letter from one cell to another
 

If I have A100 in one cell, can I create a formula that would put "100" in
the next cell? Thanks!

Formula to remove a letter from one cell to another
 

If it is always one letter to the left it is easy

=--MID(TRIM(A1),2,15)

or if you want a text number

=MID(TRIM(A1),2,255)


--
Regards,

Peo Sjoblom



"KLAOI" wrote in message
...
If I have A100 in one cell, can I create a formula that would put "100" in
the next cell? Thanks!