How To Create A Paragraph In Excel

02-10-2012,12:56 PM #1

Registered User

---

Inserting Formula Results into a Paragraph?

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

---

02-10-2012,01:17 PM #2

Re: Inserting Formula Results into a Paragraph?

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

---

02-12-2012,10:26 AM #3

Re: Inserting Formula Results into a Paragraph?

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"

Palmetto

Do you know . . . ?

You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

---

02-14-2012,10:43 AM #4

Registered User

---

Re: Inserting Formula Results into a Paragraph?

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

---

02-14-2012,08:34 PM #5

Re: Inserting Formula Results into a Paragraph?

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"

---

How To Create A Paragraph In Excel

Source: https://www.excelforum.com/excel-general/814086-inserting-formula-results-into-a-paragraph.html

Posted by: barberblied1966.blogspot.com

Share this post