how to count words and numbers in 1 row?

[Ar13f]

Dear Team,

I have data and the result I want is as below:

Identification No	Output
A1296754B	9
3675031011643218	16
TZ-11619879	11
19BF08655	9
594509-05-5885	14

I just want to count the words or numbers in the "Identification No" column above.

Regards,

Arief

[Qiu · Accepted solution]

@Ar13f 
I thought you are an artificial account since you almost give thumb up for most of my posts. 
So I have to answer this one for you.

😁

[Neer_0135 · Accepted solution]

Use the below formula in the formula tool:-

Length([Identification No])

[Ar13f]

Dear @Qiu 

Greetings from Indonesia

Oh My God ..... thank you for your quick answer ... turns out the answer is that easy ... a lot of tools and formulas in alteryx that I have to remember. 

regards,

Arief