View Single Post
  #1   Report Post  
Joao
 
Posts: n/a
Default get characters from a string in excel

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