Thread: Formula to remove a letter from one cell to another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default 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!


Reply With QuoteReply With Quote