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 <wimber...@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/ >
-. --- - / ...- .- .-.. .. -.. / -- --- .-. ... . / -.-. --- -.. . 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/