Posted to microsoft.public.excel.programming

Robert Crandal[_3_] Robert Crandal[_3_] is offline

external usenet poster

Posts: 161

Fast way to truncate string

"GS" wrote:

As Maurizio pointed out.., here's a version optimized for VB[A} use.

Excellent. I figured the best way would involve using the
Instr() function in conjunction with Mid() or Left() or whatever.

Thanks again Gary and Maurizio

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
TRUNCATE SPACE FROM NUMERICAL STRING eg "33Â 033Â 546"	NAEEM	Excel Worksheet Functions	8	December 5th 06 07:30 PM
Truncate string	bwmaher	Excel Programming	3	November 8th 06 07:11 PM
Truncate string	bwmaher	Excel Programming	0	November 8th 06 01:17 PM
How do you truncate a text string?	dailygluttony	Excel Worksheet Functions	2	March 28th 06 08:08 PM
Any fast method to parse a string into row & col information	Nick	Excel Programming	3	August 19th 04 06:47 PM

All times are GMT +1. The time now is 08:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us