Creating a paragraph of text from Excel sheet

[Dazzybeeguy]

I want to create a set of say 10 rows with a statement,

i.e 1. Name of person spoken to (the next cell would be a free type box
2. Date (The next cell would be a drop down list of the last 7 days)
3. Time (they would enter the time i.e 21:15)
4. Interpreter needed (Declined or accepted)
5. They agreed to XYZ (Yes,No)
6. Discussion took place at (Drop down list of 5 locations)
7. etc etc etc

I then want to create a paragraph of text that I can then paste to elsewhere.
The issue is, depending on the response for each row the content & size of the paragraph would alter.
Not sure how to overcome issues such as there being gaps etc

The paragraph would include the name in several places, so if its a Mr J Smith it needs so much space but if it was Mr George Michael Schwarnegger the it needs more space

I cant seem to overcome the issues of how to get it to paste intor a word doc nicely formatted.

Thanks

 

[ExceLoki]

without knowing your exact end goal of the paragraph, here's a couple of ideas that might help you
g1 manually puts together the sentence.
g2 is a bit more of a formula
g3 is all formula
hope one of these will help point you in the right direction for your end goal
----------------------

Book1
	A	B	C	D	E	F	G	H
1	Name of person spoken to	George Michael Schwarnegger		10/27/2023	Location 1	On		On Wednesday October 25, 2023 at 21:15 George Michael Schwarnegger, needed an interpreter, agreed to at Location 2 blah blah blah. Etc etc etc.
2	Date	10/25/2023		10/26/2023	Location 2	at		On Wednesday October 25, 2023 at 21:15 George Michael Schwarnegger needed an interpreter at Location 2 agreed to blah blah blah. Etc etc etc.
3	Time	21:15		10/25/2023	Location 3			On Wednesday October 25, 2023 at 21:15 George Michael Schwarnegger needed an interpreter at Location 2 agreed to blah blah blah. Etc etc etc.
4	Interpreter needed	accept		10/24/2023	Location 4
5	They agreed to XYZ	yes		10/23/2023	Location 5
6	took place at	Location 2		10/22/2023
7	etc	blah blah blah. Etc etc etc.		10/21/2023
Sheet2

Cell Formulas
Range	Formula
H1	H1	="On "&TEXT(B2,"dddd mmmm dd, yyyy")&" at "&TEXT(B3,"hh:mm")&" "&B1&", "&IF(B4="accept","needed an interpreter"," did not needed an interpreter")&", "&IF(B5="yes"," agreed to "," did not agree to")& " at "&B6&" "&B7
H2	H2	=TEXTJOIN(" ",TRUE,"On",TEXT(B2,"dddd mmmm dd, yyyy"),"at",TEXT(B3,"hh:mm"),B1,IF(B4="accept","needed an interpreter","did not needed an interpreter"),"at",B6,IF(B5="yes","agreed to","did not agree to"),B7)
H3	H3	=TEXTJOIN(" ",TRUE,F1,TEXT(B2,"dddd mmmm dd, yyyy"),F2,TEXT(B3,"hh:mm"),B1,IF(B4="accept","needed an interpreter","did not needed an interpreter"),F2,B6,IF(B5="yes","agreed to","did not agree to"),B7)
D1	D1	=TODAY()
D2:D7	D2	=D1-1

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=$D$1:$D$7
B4	List	decline, accept
B5	List	yes,no
B6	List	=$E$1:$E$5

 

[Dazzybeeguy]

without knowing your exact end goal of the paragraph, here's a couple of ideas that might help you
g1 manually puts together the sentence.
g2 is a bit more of a formula
g3 is all formula
hope one of these will help point you in the right direction for your end goal
----------------------

Book1
	A	B	C	D	E	F	G	H
1	Name of person spoken to	George Michael Schwarnegger		10/27/2023	Location 1	On		On Wednesday October 25, 2023 at 21:15 George Michael Schwarnegger, needed an interpreter, agreed to at Location 2 blah blah blah. Etc etc etc.
2	Date	10/25/2023		10/26/2023	Location 2	at		On Wednesday October 25, 2023 at 21:15 George Michael Schwarnegger needed an interpreter at Location 2 agreed to blah blah blah. Etc etc etc.
3	Time	21:15		10/25/2023	Location 3			On Wednesday October 25, 2023 at 21:15 George Michael Schwarnegger needed an interpreter at Location 2 agreed to blah blah blah. Etc etc etc.
4	Interpreter needed	accept		10/24/2023	Location 4
5	They agreed to XYZ	yes		10/23/2023	Location 5
6	took place at	Location 2		10/22/2023
7	etc	blah blah blah. Etc etc etc.		10/21/2023
Sheet2

Cell Formulas
Range	Formula
H1	H1	="On "&TEXT(B2,"dddd mmmm dd, yyyy")&" at "&TEXT(B3,"hh:mm")&" "&B1&", "&IF(B4="accept","needed an interpreter"," did not needed an interpreter")&", "&IF(B5="yes"," agreed to "," did not agree to")& " at "&B6&" "&B7
H2	H2	=TEXTJOIN(" ",TRUE,"On",TEXT(B2,"dddd mmmm dd, yyyy"),"at",TEXT(B3,"hh:mm"),B1,IF(B4="accept","needed an interpreter","did not needed an interpreter"),"at",B6,IF(B5="yes","agreed to","did not agree to"),B7)
H3	H3	=TEXTJOIN(" ",TRUE,F1,TEXT(B2,"dddd mmmm dd, yyyy"),F2,TEXT(B3,"hh:mm"),B1,IF(B4="accept","needed an interpreter","did not needed an interpreter"),F2,B6,IF(B5="yes","agreed to","did not agree to"),B7)
D1	D1	=TODAY()
D2:D7	D2	=D1-1

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=$D$1:$D$7
B4	List	decline, accept
B5	List	yes,no
B6	List	=$E$1:$E$5

Thank you, from looking at your reply I have managed to cobble something together that works.

 

[ExceLoki]

happy to help