Solved

Count number of characters

  • 19 January 2024
  • 2 replies
  • 58 views

Badge +1

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

icon

Best answer by Issam Moalla 19 January 2024, 12:02

View original

2 replies

Userlevel 5
Badge +9

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

Badge +1

Thank you, that worked! 

Reply