Google spreadsheets RE2 / RegEx - return all alpha words in string

Question

I'm trying to extract alpha sequences in strings in Google spreadsheets.

My sequences are like 75% Cotton, 15% Organic wool, 10% Polyurethane. My desired output would be Cotton, Organic wool, Polyurethane

I tried =REGEXEXTRACT(A1; "([a-zA-Z ]+),") which gives me only the first occurrence Cotton. This seems to be a known limitation. Is there another chance to get the desired result?

Do you want these in a single cell? Or do these have to spill? Could you add a screenshot how you see your results? — JvdV, Jul 06 '20 at 11:56

score 1 · Answer 1 · answered Jul 06 '20 at 11:36

1

try:

=TRIM(REGEXREPLACE(A1, "[0-9%]", ))

answered Jul 06 '20 at 11:36

player0

124,011
12
67
124

score 1 · Accepted Answer · answered Jul 06 '20 at 16:33

1

You can match 1+ digits preceded by a word boundary \b[0-9]+ followed by % and a space and replace that with an empty string.

=REGEXREPLACE(A1, "\b\d+% ", "")

answered Jul 06 '20 at 16:33

The fourth bird

154,723
16
55
70

Google spreadsheets RE2 / RegEx - return all alpha words in string

2 Answers2