CODEWITHSUNDEEP
regexgoogle-sheetsgoogle-sheets-formula
Vendrium
Vendrium

Reputation: 65

Filtering 4 capital letters

I have a couple of cells that all vary in their content, but one thing that is the same across all is that they all contain a string of 4 letters which are all capital.

Is there some way for me to only show those 4 capital letters? (through a formula)?

I'm fairly flexible in the solution here, it could either be done in the cell itself or in another cell that references the cell in question.

Upvotes: 1

Views: 47

Answers (1)

player0
player0

Reputation: 1

try:

=INDEX(IFNA(REGEXEXTRACT(A1:A, "[A-Z]{4}")))

enter image description here

Upvotes: 3

Related Questions