Inserting Formula Results into a Paragraph?

**Rob.McCarthy** · 02-10-2012, 12:56 PM

Hello Everyone,

How would I go about inserting formula results into a paragraph within a cell? I would like to create a paragraph with information from a table which can be easily copied to other programs.

EX:

Excel query.jpg

Thank you for any and all help,
Rob

**Pepe Le Mokko** · 02-10-2012, 01:17 PM

Hi
Maybe it would be easier to use Word's Mail merge combined with an excel sheet as data source ?

**Palmetto** · 02-12-2012, 10:26 AM

Your "paragraph cell" must use a formula like so:

="this is my text "&A1&" the rest of the text"

Where A1 is the cell reference.

Or you could something like:

="this is my text "&VLOOKUP(A1,MyTable,2,FALSE)&" the rest of the text"

**Rob.McCarthy** · 02-14-2012, 10:43 AM

Thank you so much, that is exactly what I was looking for. I do have one more question if you'll entertain me.

So, I've got the variables into the paragraph cell - now is there any way to format them to match the original cell? (percentage, number,

EX Result:

"System Size: 8.88 kW
(37) Suntech 240W Panels
Mean Site Quality: 891.148648648649 (0.736486486486487)
Production: 7913.4 kWh
Roof Type: Asphalt Shingle

Roof A:
Panel Count: 15
Tilt: 35°
Azimuth: 244°
Site Quality: 1004.3 (0.83)

Roof B:
Panel Count: 12
Tilt: 30°
Azimuth: 244°
Site Quality: 786.5 (0.65)

Roof C:
Panel Count: 10
Tilt: 22°
Azimuth: 244°
Site Quality: 847 (0.7)"

Thank you so much,
Rob

**Palmetto** · 02-14-2012, 08:34 PM

It would be more clear if you uploaded a sample workbook (non-sensitive data) that contained examples of the data and the desired results.

The only way to apply the formatting of the variable is to use the TEXT() function. See the Excel Help.

To format the variable as a percentage
="this is my text "&TEXT(A1,"%")&" the rest of the text"

If you need special characters like the degree symbol, you may be better served by inserting the symbol into a cell and referencing the cell
="this is my text "&A1&B1" the rest of the text"

Might return Azimuth: 244° if A1 = 244 and B1 contained the symbol.

As a two decimal place number
="this is my text "&TEXT(A1,"#.00")&" the rest of the text"