[FRIAM] Find String in Spreadsheet
Stephen Guerin
stephen.guerin at simtable.com
Sat Nov 26 13:15:28 EST 2022
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>
More information about the Friam
mailing list