Skip to main content

Hello, 

 

I have a column with IDs that either have X, either have Y number of characters. The characters are a combination between letters and numbers. I would now need to find a way to single out all the IDs with X number of characters. 

 

I was thinking of creating a 2nd column that gives me 1 if the column has X characters, 0 if Y characters. However, I am struggling to find a way how to count. Is this possible? 

 

Thank you very much in advance

Hi @Olivia Van Gerven,

To achieve this you could use the LEN function. which will return the number of characters in a text.
The output would be compared to Number of X characters.

IF(len(TEXT) = X,1) 

Hope this helps,
Issam

Thank you, that worked! 

Reply


Ask your question here!

Terms & ConditionsCookie settings