Tue, 11 Mar 2008 03:58:02 -0700 from Marcha
:
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

The function you want is called MID( ).

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...