Formula to remove a letter from one cell to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have A100 in one cell, can I create a formula that would put "100" in
the next cell? Thanks!
 
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)
 
Back
Top