Using more than one formula in a cell

[christinekenny]

I have the following in which i want to populate a notice using more than one formula, sorry my knowledge does not stretch to more than one formula

I hope I have explained easy enough as below

Any help would be much appreciated.

Thank you

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Day[/TD]
[TD]DJ[/TD]
[TD]Theme[/TD]
[TD]Body[/TD]
[TD]Sponsor[/TD]
[TD]Start Time SL[/TD]
[TD]Start Time[/TD]
[TD]End time[/TD]
[TD]Subject Line[/TD]
[TD]Notice Body[/TD]
[TD]Full Notice[/TD]
[TD]BOT LM UUID[/TD]
[TD]BOT Notice[/TD]
[TD]Happening Now Bot Notice[/TD]
[TD]Halftime Bot Notice[/TD]
[/TR]
[TR]
[TD]10/1[/TD]
[TD]1[/TD]
[TD]Joker[/TD]
[TD]<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>5L Gachas & GiftCards and Gifts Event ... Oh My![/TD]
[TD]Toss on your bobbi socks & poodle skirts then head down to where INSERT C1 will be spinning the tunes you want to hear!

Sponsored (F1)[/TD]
[TD]WS Creations[/TD]
[TD]6.00PM SLT[/TD]
[TD][/TD]
[TD]8.00PM SLT[/TD]
[TD]INSERT D1 with INSERT C1 @Sensual Delights INSERT G1
[/TD]
[TD]Toss on your bobbi socks & poodle skirts then head down to where INSERT C1 will be spinning the tunes you want to hear!

Sponsored (INSERT F1)[/TD]
[TD]INSERT D1 with INSERT C1 @ Sensual Delights INSERT G1

Sponsored by (F1)[/TD]
[TD]396dc5e9-a0dd-91a1-76e7-6a6e0829f4c5[/TD]
[TD]INSERT D1 + G1 +M1 + K1
[/TD]
[TD]HAPPENING NOW! INSERT D1@ Sensual Delights INSERT M1 + K1[/TD]
[TD]HALFTIME! INSERT D1@ Sensaul Delights INSERT M1 + K1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jmacleary]

Hi there. You can string bits together in a few ways. The way I use is with an & between each bit. The formula you would want in E2 would be:
Excel 2007 32 bit

	E
Toss on your bobbi socks & poodle skirts then head down to where dwqwdq will be spinning the tunes you want to hear! Sponsoredrht

<tbody>
[TD="align: center"]2[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]E2[/TH]
[TD="align: left"]="Toss on your bobbi socks & poodle skirts then head down to where "&C2&" will be spinning the tunes you want to hear!

Sponsored"& F2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

You would need to typealt-enter between the exclamation mark and Sponsored to get the blank lines to show in the cell.

One other way is by using the concatenate function as follows:

=CONCATENATE("Toss on your bobbi socks & poodle skirts then head down to where ",C2," will be spinning the tunes you want to hear!

Sponsored", F2)

 

[christinekenny]

Thank you for your reply and is a lot clearer for me now If I use the =concatenate formula, how would I put spaces between each please, for example =concatenate(d1,g1,m1,k1) the formula works but all the text is as one and no spaces. Thank you

 

[jmacleary]

To put a space between each cell, just insert " ". So, your example would become =concatenate(d1," ",g1," ",m1," ",k1)

 

[christinekenny]

Thank you so much... Have a great day

 

[jmacleary]

You're welcome and thanks for the feedback.