Any function for Crop/Cut Text

  • Thread starter 0-0 Wai Wai ^-^
  • Start date
0

0-0 Wai Wai ^-^

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.
 
B

Bernie Deitrick

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
 
Top