Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Im trying to ask questions of a string. My string is in "A1". I
assign it to 'teststring' which looks like "A 2 3 A 4" This can be any combination with or without A or Numbers and contain 3 values upto 5. Id like to ask this of my string. Does it contain "A", If yes How many....if more than 1 then....how many values in string altogether.....if 3 go do something if three add the numbers up in the string and use the A's as 1 eg 'A A 2 3 4' = 11. Does it contain A, if no add al the values. I could do with knowing the position of the A's but that a minor prob. When I was doing this with 2 values I used If InStr("A", TestString) 0, as advised prev and this was great. Hope this makes sense. Regards Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
How can I count strings within strings | Excel Worksheet Functions | |||
Finding strings within strings | Excel Programming | |||
Finding strings within strings | Excel Programming |