How to Multiply value using repeat function and get output in same cell

[praveenvj]

Hi All,

I am very much new of using advanced excel

I have the below requirement

Insert * symbol from the list and multiply with a number

I was able to achieve this followed the below procedure

Insert numbers from 1-10 and in one column use data validation and pick Allow List and input the rows from =$D$2:$D$11

Now in the list drop down Ican see/pick 1 - 10 numbers

In one more column I used the formula



=REPT("*",B2) B2 is the list which was created earlier

Now the output is multiply * with the number picked from list and display

This is working fine but the requirement is output should be display in the list column it self

formula is wrong but i want the output in this fashion =REPT("*",=$D$2:$D$11)

where D2-D10 are list numbers

Thanks