Formula Assistance

[A_Rookie]

Question.
How can I use the mathematical value of one cell as a "text value" in
another.
I suppose what I need the cells mathematical value as a "text string"
in another cell.

For example,
I have three Columns-----Column A, Column B, Column C

Column A= "Stations"
Column B= "Sets"
I am solving for Column C= "Average Reps"

Column A Column B Column C
Stations Sets Average Reps
15 45 X
15 45 X
12 36
12 24

Pretty straight forward how to do this.

Column C =3 =sum(b1/a1)

However, what I want to do is create a formula that will allow me to
place text description in the Average Reps cell.


For example, in Average Reps Cell "C" I would like
=sum(b1/a1)& " Reps by"{value of colum A}<---{Right there, I want
whatever the number is in cell under column A}

After the word "by", I want to have the cell contents of column a1 to
show up...

So, using the example above, the cells will look like this

Column A Column B Column C
Stations Sets Average Reps
15 45 3 Reps by 15
15 45 3 Reps by 15
12 36 3 Reps by 12
12 24 2 Reps by 12


I tried the formula

=SUM(b1/a1)&" by" a1

and of course this does not work.

I'm not sure how to properly treat Column A's value as "Text" for
Column C's Text Description.

 

[Bob Phillips]

Almost there.

Not the SUM is redundant.

=B1/A&" Reps by"&A1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Java_Rookie]

Thank you!
I thought I was dancing around it...
"Rookie"