Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
substring matching functions (need a hand please)
Hi all, I am a very new Excel macro functions user. I was looking for a function able to check if a substring is or no present in another string. i.e. if the string "--------AB-------" contains the string "AB" sorry for the newbie question and thx al -- Ciccio_Drin ----------------------------------------------------------------------- Ciccio_Drink's Profile: http://www.excelforum.com/member.php...fo&userid=3100 View this thread: http://www.excelforum.com/showthread.php?threadid=50671 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
substring matching functions (need a hand please)
Hi Ciccio_Drink,
Look at the InStr function in VBA help: '============= Public Sub Tester001() Dim sStr As String sStr = " A horse, my Kingdom for a horse" If InStr(1, sStr, "xhorse", vbTextCompare) 0 Then _ MsgBox "substring found!" End Sub '<<============= --- Regards, Norman "Ciccio_Drink" wrote in message news:Ciccio_Drink.22hxmz_1138706101.8006@excelforu m-nospam.com... Hi all, I am a very new Excel macro functions user. I was looking for a function able to check if a substring is or not present in another string. i.e. if the string "--------AB-------" contains the string "AB" sorry for the newbie question and thx all -- Ciccio_Drink ------------------------------------------------------------------------ Ciccio_Drink's Profile: http://www.excelforum.com/member.php...o&userid=31003 View this thread: http://www.excelforum.com/showthread...hreadid=506710 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
substring matching functions (need a hand please)
Hi Ciccio_Drink,
To see the message, replace "xhorse" with "horse" --- Regards, Norman "Norman Jones" wrote in message ... Hi Ciccio_Drink, Look at the InStr function in VBA help: '============= Public Sub Tester001() Dim sStr As String sStr = " A horse, my Kingdom for a horse" If InStr(1, sStr, "xhorse", vbTextCompare) 0 Then _ MsgBox "substring found!" End Sub '<<============= --- Regards, Norman |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
substring matching functions (need a hand please)
I just found the answer function InStr ( "String1", "String2" ) -- Ciccio_Drink ------------------------------------------------------------------------ Ciccio_Drink's Profile: http://www.excelforum.com/member.php...o&userid=31003 View this thread: http://www.excelforum.com/showthread...hreadid=506710 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
substring matching functions (need a hand please)
thank you very much Norman, Cicci -- Ciccio_Drin ----------------------------------------------------------------------- Ciccio_Drink's Profile: http://www.excelforum.com/member.php...fo&userid=3100 View this thread: http://www.excelforum.com/showthread.php?threadid=50671 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX AND MATCHING FUNCTIONS | Excel Worksheet Functions | |||
matching or lookup functions | Excel Worksheet Functions | |||
Index & Matching Functions | Excel Discussion (Misc queries) | |||
y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
y-axis moves from the left hand side to the right hand side! | Charts and Charting in Excel |