| 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 |
|
#2
|
|||
|
|||
|
=MID(A1,5,4)
Good luck, Henrik "Joao" wrote: 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 |
|
#3
|
|||
|
|||
|
It works very well.
Thank YOU!! "Henrik" wrote: =MID(A1,5,4) Good luck, Henrik "Joao" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
