get characters from a string in excel

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

Guest

Hi!
I have a cell with a text string from wich I need to retreive just a part of
it.
Imagine that the text string has 10 charaters like ABCDEFGHIJ in cell A1.
What formula should I use in order to obtain, in cell B1, just the charaters
from position 5 to 8 that, in this case the result should be EFGH?
Thank for your help!
Joao
 
Back
Top