Transfering a Numerical Value to Text Objects

  • Thread starter Thread starter Ken H
  • Start date Start date
K

Ken H

How do I go about having a cell have text values based on
another cell's value?
For example,
A1=3
B1=5
C1=2
I want the second row then to have text values
including "*"s based on the values in the first row (with
the corresponding column). So I want the second row to
return text values as such:
A2= "***"
B2= "*****"
C2= "**"
Thanks - Ken
 
Back
Top