Consulting

Results 1 to 3 of 3

Thread: Counting The item that separate by | character

  1. #1
    VBAX Mentor
    Joined
    Feb 2012
    Posts
    406
    Location

    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.

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    =IF(ISBLANK(A2),0,LEN(A2)-LEN(SUBSTITUTE(A2,"|",""))+1)

  3. #3
    VBAX Mentor
    Joined
    Feb 2012
    Posts
    406
    Location
    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
  •