Apologies if this is the wrong area to post however my knowledge of excel is such that I don't know which subsection this problem would go in.
So my dilemma is I make personalised products, chocolates and customers send me the message they want in chocolate and we produce and box it.. For example 'I LOVE YOU DAD XX' or 'HAPPY BIRTHDAY SARAH X' Each letter is made individually and then we spell out the message as we put the chocolates in to the box. As the number of orders we have has increased I wanted to fashion a way in which we can copy & paste all the messages we receive to make each day into excel and then, by some excel magic, have an output which tells us how many of each letter we need to produce each day. Eg using the above two example messages given earlier the output would tell us we need to produce 2x the letter I; 1x L; 2x O; 1x V; 1x E; 3x Y; 3x D; 5x A and so on..
Does anyone know any way we could do this is excel? We currently do it manually with good old pen paper and tallys, I have thought of typing each letter in a separate cell then doing a query on the page as to how many of each letter were found (this is probably really showing my amateurish excel skills up now !). Anyway if anyone knows any way we could do it (and explain it in basic language!) I would be super grateful. Many thanks in advance!