PC Review


Reply
 
 
0-0 Wai Wai ^-^
Guest
Posts: n/a
 
      7th Sep 2005

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 )

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


 
Reply With Quote
 
 
 
 
0-0 Wai Wai ^-^
Guest
Posts: n/a
 
      8th Sep 2005
Note:
I have moved my question to "microsoft.public.excel.worksheet.functions"


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
vba to crop a picture Southern at Heart Microsoft Access VBA Modules 5 6th Apr 2011 09:36 PM
pst2gb won't let me indicate how many MBs to crop taugsbur Microsoft Outlook Discussion 1 30th Mar 2009 01:54 AM
Is there a way to crop text in an Excel cell? =?Utf-8?B?Y29jaHJhbnJn?= Microsoft Excel Misc 5 13th Dec 2005 03:02 PM
Crop Text to Col Width rrstudio2@icqmail.com Microsoft Excel Programming 1 17th Nov 2005 08:02 PM
Any function for Crop/Cut Text 0-0 Wai Wai ^-^ Microsoft Excel Worksheet Functions 1 8th Sep 2005 01:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:44 AM.