Crop text

Hi.
How can I do the following:
- crop text from the left
eg: CropText(A1, Crop3WordFromLeft)

- crop text from the middle

- crop text from the right

- crop specific texts from left/middle/right
eg: CropText(A1, Crop_'so to speak'_If_Found_from_right )

--
Additional information:
- I'm using Office XP
- I'm using Windows XP

Note:
I have moved my question to "microsoft.public.excel.worksheet.functions"