Forum Discussion
Vimal_Gaur
Sep 12, 2023Brass Contributor
each letter of word in to separate cells
I need to extract the each letters of a word / words in to each separate cells. (example attached) or I need to count the occurrence in of a particular letters in a table. (example attached) ...
- Sep 12, 2023
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.
Riny_van_Eekelen
Sep 12, 2023Platinum Contributor
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
Oct 24, 2023Brass Contributor
Yes, I misunderstood, but eventually got it. Thank you so much again. That was brilliant and simple.
I have also written something in VBA that will also extract, attached is the file.