Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
sorry, must control the length
Function Mid2( _ sString As String, _ lStart As Long, _ Optional lLength As Long) As String If Len(sString) < lStart + 1 Then Mid2 = Right(sString, Len(sString) + 1 - lStart) If lLength Len(Mid2) Then Mid2 = Left(Mid2, lLength) End If End If End Function regards r |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alternate ways to extract a substring? | Excel Programming | |||
R: Alternate ways to extract a substring? | Excel Programming | |||
The error of my ways. | Excel Discussion (Misc queries) | |||
256 ways to make hamburger | Excel Worksheet Functions |