Combinations of Replace, Left, Right, Mid, InStr, InStrRev, Split, etc. are usually how these are
done. Post examples of before and after.

HTH,
Bernie
MS Excel MVP


"0-0 Wai Wai ^-^" wrote in message ...

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 )


If it is not possible, any workaround is appreciated.

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