ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   * Character (https://www.excelbanter.com/excel-worksheet-functions/32381-%2A-character.html)

Kevin

* Character
 
I am trying to write a vb program that searches for the following item "GS*".
When I do a search for this I find other items such as "GS1" or "GSUT" that
are also in the spreadsheet. I realize the * character is a wild card when
doing searches. Since this character is used and I'd like to do a search for
"GS*" is there anyway I can do this?

Thank you.
Kevin

Jim

Try Ctrl-F gs*~*

"Kevin" wrote in message
...
I am trying to write a vb program that searches for the following item

"GS*".
When I do a search for this I find other items such as "GS1" or "GSUT"

that
are also in the spreadsheet. I realize the * character is a wild card

when
doing searches. Since this character is used and I'd like to do a search

for
"GS*" is there anyway I can do this?

Thank you.
Kevin





All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com