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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select a string of characters 7
Extracting the last word from a string. 2
find and replace numeric strings in larger text strings 8
Excel - How to identify a letter in side a cell 1
A find formul looking at two named ranges for two strings 6
Counting Characters in a Cell 2
How to extract a character from a string then VLOOKUP a table? 7
Excel custom format q 3

Back
Top