How to combine the content from eg. 3 cells into a new cell
 

Hi

In colimn A cell 1, I have entered the number 100
In column B cell 1, I have entered the number 10
In column C cell 1, I have entered the number 1001

Then I want to combine this data into cell 1 in column D to show
100-10-1001 - How can I do this?
Thanks in advance.

How to combine the content from eg. 3 cells into a new cell
 

If all you want is the numbers from A1, B1 and C1 in D1 separated by
dashes...

=A1&"-"&B1&"-"&C1

--
Rick (MVP - Excel)


"Kammam" wrote in message
...
Hi

In colimn A cell 1, I have entered the number 100
In column B cell 1, I have entered the number 10
In column C cell 1, I have entered the number 1001

Then I want to combine this data into cell 1 in column D to show
100-10-1001 - How can I do this?
Thanks in advance.

How to combine the content from eg. 3 cells into a new cell
 

CONCATENATE() is the function to combine text strings.

Alternatively you can use teh ampersand &

=A1&"-"&B1&"-"&C1

If this post helps click Yes
---------------
Jacob Skaria


"Kammam" wrote:

Hi

In colimn A cell 1, I have entered the number 100
In column B cell 1, I have entered the number 10
In column C cell 1, I have entered the number 1001

Then I want to combine this data into cell 1 in column D to show
100-10-1001 - How can I do this?
Thanks in advance.