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 ^-^" 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