Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Text String in Excel | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions |