-
Counting The item that separate by | character
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 :
Count.png
Appreciate for your help and time .
Regards.
-
=IF(ISBLANK(A2),0,LEN(A2)-LEN(SUBSTITUTE(A2,"|",""))+1)
-
Appreciate for your great help . Thank you so much .
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules