EXCEL 1997 FORMULA QUESTION
Where is the color number? Where are the number of items for the color?
If it helps, with color number (36) in A1 and the count (3) in A2, the
following will produce "36,,,":
=a1&rept(",",a2)
Regards,
Fred.
"JENN" wrote in message
...
I am trying to keep track of objects of various colors. Lets say that the
color white is represented by the number 51 and I have 3 items in the
color
white. I want the cell to read "51,,,". I also want the number 36 to
represent the color black, which I have 6 of (E.G. "36,,,,,,"). Then I
want
this data to be used on another worksheet and show 3 for white and 6 for
black.
--
JENN
"Fred Smith" wrote:
Something like this:
=a1&","&a2
If that's not what you're looking for, be more specific about what you
want
to do.
Regards,
Fred
"JENN" wrote in message
...
I have excel 1997 and I have been trying to keep track of some data. I
understand how to use a formula to add numbers, but I want to add
symbols
(to
be exact, commas) not numbers.
--
JENN
|