Formula to remove a letter from one cell to another

K

KLAOI

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

Peo Sjoblom

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)
 
Top