need help with this situation

Please describe what the problem is, or what you need to have happen.

Hi Adriana,

Use below formula in D7 and drag down and across:

=LEN(D$14)-LEN(SUBSTITUTE(D$14,$A7,""))

Select allOpen in new window

Please find attached...
Adriana_Count-Letters.xlsx

Shums   ,,,  Martin Liss


when i write this

need get this

in this case 2 is = to BB

but any time i write 2 i need get it double
or triple  let's say  3 in the B is equal to BBB

i need write the number and get the corresponded letter combination

Shums i try sorry i don't get it work as needed

i need writhe the number in the area and get write the code

like the example i i show

shum when i write it in your table it erease the formula

i need writhe the numbers as needed  then get the code

Shum  and  Martin Liss

Thanks !!

I have to say  my mind is not computer orientet

and some times i can't  NOT understand  like you !!

Thanks !! Great Experts !!
Great  Solutions !!

Hi Adriana,

Please find attached with formula
Adriana_Count-Letters_v3.xlsx