<div dir="auto">There's a bunch of functions that take a range of cells as input and different outputs depending on use case (find,  search,  match, vlookup, hlookup, etc)<div dir="auto"><br></div><div dir="auto">Examples here: <a href="https://www.exceldemy.com/excel-search-for-text-in-range/">https://www.exceldemy.com/excel-search-for-text-in-range/</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Nov 26, 2022, 8:42 AM Frank Wimberly <<a href="mailto:wimberly3@gmail.com">wimberly3@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I used to know Excel pretty well but that was decades ago.  I want to find a given string, say "Wimberly" in a large spreadsheet.  How do I do that simply?  FIND function wants to provide the location within a larger string of a substring.  I want something like the Unix "grep' command.  <br clear="all"><div><br></div>-- <br><div dir="ltr" data-smartmail="gmail_signature"><div dir="ltr">Frank Wimberly<br>140 Calle Ojo Feliz<br>Santa Fe, NM 87505<br>505 670-9918<div><br></div><div>Research:  <a href="https://www.researchgate.net/profile/Frank_Wimberly2" target="_blank" rel="noreferrer">https://www.researchgate.net/profile/Frank_Wimberly2</a></div></div></div></div>
-. --- - / ...- .- .-.. .. -.. / -- --- .-. ... . / -.-. --- -.. .<br>
FRIAM Applied Complexity Group listserv<br>
Fridays 9a-12p Friday St. Johns Cafe   /   Thursdays 9a-12p Zoom <a href="https://bit.ly/virtualfriam" rel="noreferrer noreferrer" target="_blank">https://bit.ly/virtualfriam</a><br>
to (un)subscribe <a href="http://redfish.com/mailman/listinfo/friam_redfish.com" rel="noreferrer noreferrer" target="_blank">http://redfish.com/mailman/listinfo/friam_redfish.com</a><br>
FRIAM-COMIC <a href="http://friam-comic.blogspot.com/" rel="noreferrer noreferrer" target="_blank">http://friam-comic.blogspot.com/</a><br>
archives:  5/2017 thru present <a href="https://redfish.com/pipermail/friam_redfish.com/" rel="noreferrer noreferrer" target="_blank">https://redfish.com/pipermail/friam_redfish.com/</a><br>
  1/2003 thru 6/2021  <a href="http://friam.383.s1.nabble.com/" rel="noreferrer noreferrer" target="_blank">http://friam.383.s1.nabble.com/</a><br>
</blockquote></div>