for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

Snail Jan 2024 12:53pm, 16 Jan 2024 2,641 posts	Quote Pin Snail If just low volume and simply liking to find, then conditional formatting..... highlight cell rules ...text that contains..... , would work
Snail Jan 2024 12:57pm, 16 Jan 2024 2,642 posts	Quote Pin Snail Or if you wanted a column of True/false next to your data to look for the commas then this should work =sum product(--isnumber(search({","},A1)))>0 would also be an option
HappyG(rrr) Jan 2024 1:09pm, 16 Jan 2024 49,164 posts	Quote Pin HappyG(rrr) I've been using Excel for 25 years, and I never knew " -- " In Excel, using two minus signs next to each other (--) converts "TRUE" to 1 and "FALSE" to 0. Example : Let's take a simple logical condition : 3 > 2 . Apply this in Excel = 3 > 2 returns "TRUE". Using "--" (two minus signs together) with this condition returns 1 = --(3 > 2) . I must be a 3 out of 10 level user! Thanks! G
larkim Jan 2024 1:46pm, 16 Jan 2024 22,997 posts	Quote Pin larkim I will readily admit that I never knew that one either HG. And I thought I was half decent, especially with the basics!
GlennR Jan 2024 3:29pm, 16 Jan 2024 74,106 posts	Quote Pin GlennR You can also multiply through TRUE and FALSE outputs, with the first acting as 1 and the second as 0.
JamieKai chameleon Jan 2024 3:56pm, 16 Jan 2024 18,228 posts	Quote Pin JamieKai chameleon I think you need the newer version of excel for this to work: =IFERROR(TEXTAFTER(A1,", ")&" "&TEXTBEFORE(A1,", "),A1) Just change A1 for the column where your names are. CBN - thanks - this works, although my brain hurts trying to figure out why it works!
JamieKai chameleon Jan 2024 4:07pm, 16 Jan 2024 18,229 posts	Quote Pin JamieKai chameleon OK, penny just dropped. Brilliant
HappyG(rrr) Jan 2024 4:12pm, 16 Jan 2024 49,168 posts	Quote Pin HappyG(rrr) & for concatenation is new to me too. Every day's a school day. And double Excel lessons today. G
larkim Jan 2024 4:30pm, 16 Jan 2024 22,998 posts	Quote Pin larkim Now I am surprised "&" had passed you by; that's been at my fingertips since the late 1990s, thought everyone used that now.
SPR Jan 2024 4:35pm, 16 Jan 2024 43,485 posts	Quote Pin SPR I always use &. I've also used what Glenn does as TRUE is 1 and FALSE is 0 as he said. Never knew about -- though.