I have identification numbers and letters which go on telephone boxes.
Like CVR 1-2-3-4-R
DVR 5-6-7-8-9-11-L
DVR-0-1R
What I need is to find the total number of letters and numbers I need for the job.
I did a find and replace with a blank which deletes that item and I write the number of deletions down. I continue until nothing is left. I need numbers 0 thru 9, letters A-Z and any other character like "-".
Above example C=1,D=2,V=3,R=5 etc. My list is in Colulmn "A" and the count can be Column "B"
Thanks