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

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

Date

Day

DJ

Theme

Body

Sponsor

Start Time SL

Start Time

End time

Subject Line

Notice Body

Full Notice

BOT LM UUID

BOT Notice

Happening Now Bot Notice

Halftime Bot Notice

10/1

1

Joker

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>5L Gachas & GiftCards and Gifts Event ... Oh My!

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)

WS Creations

6.00PM SLT

8.00PM SLT

INSERT D1 with INSERT C1 @Sensual Delights INSERT G1

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)

INSERT D1 with INSERT C1 @ Sensual Delights INSERT G1 Sponsored by (F1)

396dc5e9-a0dd-91a1-76e7-6a6e0829f4c5

INSERT D1 + G1 +M1 + K1

HAPPENING NOW! INSERT D1@ Sensual Delights INSERT M1 + K1

HALFTIME! INSERT D1@ Sensaul Delights INSERT M1 + K1

<tbody>
</tbody>

 

[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
2	Toss on your bobbi socks & poodle skirts then head down to where dwqwdq will be spinning the tunes you want to hear! Sponsoredrht

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula E2 ="Toss on your bobbi socks & poodle skirts then head down to where "&C2&" will be spinning the tunes you want to hear! Sponsored"& F2 <tbody> </tbody>

<tbody>
</tbody>

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.