+1Hello,
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
Best answer by Issam Moalla
Hi
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
+11Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.