| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get part of text in a Cell
I don't know how to search for this Function - but I'm sure I have seen it.
I have a text-cell - and in that cell I want to retrieve a 'Code' that is placed within the cell. The 'Code' is between a [ and ] - like: [OT] 1 june. I want the [OT] to be written in another cell in the row. (Don't wanna remove it from the current cell - just copy it) I know I can get the posistion with FIND("[";F6) and FIND("]";F6) Now I just want to place it in J6 - something like: GetText(F6;1;3) - and the result would be [OT] in the cell F6 :D Thank you for easing a lot of minds :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| USE PART OF TEXT FROM ONE CELL IN ANOTHER | Excel Discussion (Misc queries) | |||
| delete part of text from a cell | Excel Worksheet Functions | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| format part of text in a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
