ExcelBanter - Find a String in a Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Find a String in a Cell (https://www.excelbanter.com/excel-programming/322453-find-string-cell.html)

jerry chapman[_2_]

Find a String in a Cell

I want to get the value of a cell and search for a specified string in that
value. How could I do that? I have looked for a "find" command without
success.

Ron Rosenfeld

Find a String in a Cell

On Sat, 05 Feb 2005 04:06:23 GMT, "jerry chapman"
wrote:

I want to get the value of a cell and search for a specified string in that
value. How could I do that? I have looked for a "find" command without
success.

For Excel, type "FIND worksheet function" into the Help box. Also look at the
SEARCH function.

For VBA, you may also use INSTR.

--ron

All times are GMT +1. The time now is 02:27 PM.