Posted to microsoft.public.excel.programming

Mark[_57_] Mark[_57_] is offline

external usenet poster

Posts: 2

parsing a string

i'm writing a macro from within excel 2003. if i have a string with value
"abc", how do i select just "ab".

i tried the left(string,number) function (which i use in VB all the time)
but i guess within excel that doesnt' work?

thanks.

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
parsing on a date string pulled from a database.	Zone99	Excel Discussion (Misc queries)	3	July 9th 07 11:49 PM
Parsing when deliminator is a string	Rose	Excel Worksheet Functions	5	December 14th 04 12:54 AM
Parsing a String to get Numbers	nabukhalaf[_2_]	Excel Programming	4	October 6th 04 12:05 AM
Parsing a string to retrieve numerals	nabukhalaf	Excel Programming	2	October 5th 04 10:23 PM
Unicode string parsing? Please help!	Douglas Gennetten[_2_]	Excel Programming	1	January 16th 04 08:31 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us