98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
Excel VBA
Resolved · High Priority · Version 2007
Wed 12 Oct 2011, 15:26Delegate Steve said...
Steve has attended:
Excel VBA Intro Intermediate course
Excel VBA
What is the best way to find a particular word in a string. The word always appears as the last word but the string length does vary. For example, how would I find the word "Total" in the below examples:
"Euro Conversion Total"
"Conversion Total"
I have tried using the "Instr" function but I am only able to get this to work if the target word appears at the front of the string:
If InStr(1, i, "Total", vbBinaryCompare) = 1 Then
Thanks
Mon 17 Oct 2011, 16:17Trainer Mark said...
RE: Excel VBA
Hello Steve,
You may try using the wildcard in the criteria, such as "*total" to find anything that ends in total, or "*total*" to find it anywhere.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using basic functions without doing formulasWhen you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums. |
