Select a string without knowing position
I want to find a string (word) in every row of a range; whenever I find
it, I activate it, and do someting, and move on to next row, until I touch all rows. The position of the word in a cell is not fixed, so I cannot use LEFT or RIGHT Please help |
Select a string without knowing position
WIA,
Use the "InStr" function Jim Cone San Francisco, USA "Who I Am" wrote in message oups.com I want to find a string (word) in every row of a range; whenever I find it, I activate it, and do someting, and move on to next row, until I touch all rows. The position of the word in a cell is not fixed, so I cannot use LEFT or RIGHT Please help |
All times are GMT +1. The time now is 08:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com