How to Summarize Data in a sentence?

[Confused]

I know I've seen this, should have written it down at the time, but wasn't
ready to implement it then, but now I need it.

I want to take some various cells and create a new cell based on them, only
have it display in a sentence. Something like "A 5 inch by 3 inch green
sheet with rounded edges" where the values 5, 3, green, sheet, and rounded
are stored in various cells and would of course change depending on other
options.

I know it's simple, but can't find anything in the help.

Thanks in advance
Conf.

 

[Laura Cook]

With the data in A1, B1, C1, D1, and E1:

="A "&A1&" inch by "&B1&" inch "&C1&" "&D1&" with "&E1&" edges"

 

[John]

HI
You can do it this way =A1&" "&B1&" "&C1
The cell numbers would hold the information or you can place text in"TEXT"
double quotes.
HTH
John

 

[Bernard Liengme]

="A " & A1 & " inch by " & B1 & " inch " & C1 & " " &D1 & " with " & E1 & "
edges"
Where A1:E1 hold your variables
If an number is the result of a calculation you may need in place of just A1
something like
TEXT(A1,"#.00") to see 5.25
best wishes

 

[CurlyDave]

I know I've seen this, should have written it down at the time, but wasn't
ready to implement it then, but now I need it.

I want to take some various cells and create a new cell based on them, only
have it display in a sentence. Something like "A 5 inch by 3 inch green
sheet with rounded edges" where the values 5, 3, green, sheet, and rounded
are stored in various cells and would of course change depending on other
options.

I know it's simple, but can't find anything in the help.

Thanks in advance
Conf.

="A "& A1&" inch by "&b1&" inch "&c1&" "&d1&" with rounded edges"
I think you get the idea

 

[Confused]

Excellent! Thanks everyone, I knew it was simple. Works perfectly.

Conf.

 

[John]

You're welcome, now you're no longer confused
Regards
john