How to select cells in google sheets that have a comma?

E

eldgammel2021-04-27 01:02:19

Google Sheets

eldgammel, 2021-04-27 01:02:19

Hello, I have one column from A2 to A2500.
1. select cells in which there is a comma
2. select cells in which only one word
is two different operations. Help pliz)

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2021-04-27
@eldgammel

1. select cells that have a comma

=filter(A2:A;REGEXMATCH(A2:A;"\,"))

2. select cells in which there is only one word

=ArrayFormula(filter(A2:A;REGEXMATCH(""&A2:A;"^[0-9a-zA-Zа-я-А-ЯёЁ]+$")))

or

=ArrayFormula(filter(A2:A;REGEXMATCH(""&A2:A;"^\S+$")))