If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pass a calculated form field to a subform field? | Brook | Using Forms | 22 | April 28th, 2005 04:56 PM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
Concatenatd fields in a query for a searching form | Marc | Running & Setting Up Queries | 8 | October 19th, 2004 08:49 PM |