[FRIAM] Find String in Spreadsheet

[Stephen Guerin]

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)

Examples here: https://www.exceldemy.com/excel-search-for-text-in-range/

On Sat, Nov 26, 2022, 8:42 AM Frank Wimberly <wimberly3 at gmail.com> wrote:

> 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.
>
> --
> Frank Wimberly
> 140 Calle Ojo Feliz
> Santa Fe, NM 87505
> 505 670-9918
>
> Research:  https://www.researchgate.net/profile/Frank_Wimberly2
> -. --- - / ...- .- .-.. .. -.. / -- --- .-. ... . / -.-. --- -.. .
> FRIAM Applied Complexity Group listserv
> Fridays 9a-12p Friday St. Johns Cafe   /   Thursdays 9a-12p Zoom
> https://bit.ly/virtualfriam
> to (un)subscribe http://redfish.com/mailman/listinfo/friam_redfish.com
> FRIAM-COMIC http://friam-comic.blogspot.com/
> archives:  5/2017 thru present
> https://redfish.com/pipermail/friam_redfish.com/
>   1/2003 thru 6/2021  http://friam.383.s1.nabble.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://redfish.com/pipermail/friam_redfish.com/attachments/20221126/605f10fd/attachment.html>