| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Insert function right on text values e.g. 0180001640 | Excel Worksheet Functions | |||
| How can I combine text and a function in a single cell | Excel Worksheet Functions | |||
| How do I add help text to an excel function I have created | Excel Worksheet Functions | |||
| dollar figure to text function | Excel Worksheet Functions | |||
| Function within a TEXT FORMULA | Excel Worksheet Functions | |||
Linear Mode
