Results 1 to 3 of 3

Thread: Count number of occurrences of text in the same cell separated by ";"

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Aug 2016
    Posts
    2
    Location

    Count number of occurrences of text in the same cell separated by ";"

    Dear Experts,

    This is my first post, so please excuse me if I break any rules. I am glad to be part of the Forum and appreciate any assistance.
    I am facing a problem in the last step of my project where i need to give the compiled data.
    I have the output so far as below in a single cell, for example in "C1":

    Apple; Apple; Apple; Apple; Banana; Banana; Apple

    I need it to become in the same cell "C1":

    5 Apple; 2 Banana

    I've multiple cells in the same column C which needs to become as above.

    Example again:

    Data in below form...

    Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple; Apple
    Banana; Apple; Grapes
    Banana; Apple; Grapes; Banana; Apple; Grapes
    Apple
    Apple; Apple; Banana; Grapes; Grapes

    Required Output as below:

    12 Apple
    1 Banana; 1 Apple; 1 Grapes
    2 Banana; 2 Apple; 2 Grapes
    1 Apple
    2 Apple; 1 Banana; 2 Grapes
    Last edited by mfarhan; 08-08-2016 at 10:34 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •