Any function for Crop/Cut 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 )


If it is not possible, any workaround is appreciated.

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

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 ^-^" <[email protected]> wrote in message news:%[email protected]...
>
> 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
>
>