Display Contents Of Cell A1 & B1 in C1

N

Notts_Lad

Hi,

I wonder if someone could help me out.

I need a function or formula that will look at what ever data is i
Cell A1 and B1 and display them into cell 1 but seperated by a "-
symbol.

For Eaxample:

A1 B1 C1
Some Text More Text Some Text - More Text

Is this possible and how do I do it?

Thank you in advance,


Kenn
 
K

Kenji

Hi Notts,
Just make C1 = CONCATENATE(A1, "-", B1)

Good luck and have fun!

Kenjiro Yagi
 
B

BenjieLop

I hope this will help ...

=A1&" - "&B1

Notts_Lad said:
Hi,

I wonder if someone could help me out.

I need a function or formula that will look at what ever data is i
Cell A1 and B1 and display them into cell 1 but seperated by a "-
symbol.

For Eaxample:

A1 B1 C1
Some Text More Text Some Text - More Text

Is this possible and how do I do it?

Thank you in advance,


Kenn
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing the values of multiple cells in conditinal formatting. 0
Help with IF Function for times. 5
can a cell be both input and output? 3
Copy A1 into C1 if B1 contains data?? 2
Conditional Formatting Formula 3
Show value from one cell in another cell if today falls between a date range 5
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Excel - Wich Function should I use? 1

Top