Posted to microsoft.public.excel.programming

r[_4_]

external usenet poster

Posts: 7

R: Alternate ways to extract a substring?

Hi Robert

Function Mid2( _
sString As String, _
lStart As Long, _
Optional lLength As Long) As String

Mid2 = Right(sString, Len(sString) + 1 - lStart)
If lLength Len(Mid2) Then
Mid2 = Left(Mid2, lLength)
End If
End Function

regards
r

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Alternate ways to extract a substring?	Robert Crandal[_2_]	Excel Programming	1	April 15th 11 11:14 AM
The error of my ways.	Cerberus	Excel Discussion (Misc queries)	5	February 19th 08 09:36 PM
256 ways to make hamburger	Nonni	Excel Worksheet Functions	2	October 20th 06 11:50 PM
different ways to copy a range?	botha822[_3_]	Excel Programming	4	August 8th 06 12:06 AM
Ways of Summarising data	BM	Excel Discussion (Misc queries)	1	February 2nd 06 09:07 AM

All times are GMT +1. The time now is 04:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us