How do i pull a the begining of this string but not the end..
string = 12345/67890
i want new_string = 12345
any help will be most appricated
thanks
brooke
Printable View
How do i pull a the begining of this string but not the end..
string = 12345/67890
i want new_string = 12345
any help will be most appricated
thanks
brooke
new_string = Left$(string, 5)
------------------
Marty
What did the fish say when it hit the concrete wall?
> > > > > "Dam!"
WHAT IF ITS 123456/799483 i want everything in front of the /
Try this:
Dim strText As String
strText = "12345/abcd
strText = Left(strText, InStr(strText, "/") - 1)
------------------
Serge
Senior Programmer Analyst
[email protected]
[email protected]
ICQ#: 51055819