PDA

View Full Version : [SOLVED] Counting The item that separate by | character



parscon
09-04-2018, 05:01 AM
Hello Every One .
I have Data Like This in Column G , ABCD|EFGH&DB|EX.ADL|GLMS/S|CXT-DFL|S3A21/86 That Separate by | and i need to count the data on each cell and write in The H Column...
Mean the result will be like this :

22820

Appreciate for your help and time .

Regards.

Kenneth Hobs
09-04-2018, 12:23 PM
=IF(ISBLANK(A2),0,LEN(A2)-LEN(SUBSTITUTE(A2,"|",""))+1)

parscon
09-05-2018, 01:27 AM
Appreciate for your great help . Thank you so much .