Forum Discussion
each letter of word in to separate cells
Vimal_Gaur Provided you are using Excel365 or 2021, have a look at the attached file.
The green shaded areas is where I entered my formulas.
Vimal_Gaur Provided you are using Excel365 or 2021, have a look at the attached file.
The green shaded areas is where I entered my formulas.
I know the COUNTIF formula, I can do the counting myself.
I need to extract the letters in separate cells or if you can count the letters in the whole string.
e.g. 1. "Vimal Gaur" in a single cell B11 (find how many A are there in this word)
e.g. 2. "Rozer Ramon is lives right on bank of river" now find occurrence of each letter in this string.
Vimal_Gaur I merely replicated what was in your file. But WITH formulas. Did you note the formula in C11 and below? That's splitting each text string in B into separate cells. If that's not what you wanted, I misunderstood.
simple
A1 contains "States"
B1 "S", C1 "t", D1 "a", E1 "t", F1 "e", G1 "s"
or
A1 contains "States"
B1 "S", C1 2
B2 "t", C2 2
B3 "a", C3 2
B4 "e", C3 2purpose - I want gift Table Clock with personal name written on clock's side panel. I have to give the quantity of each letter to the printing guy. So he will print exact quantity with sequence so that it will be easy for my to paste on the panel.
I believe that exactly what I demonstrated in my file. If not, you have lost me, sorry.
