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

  • Thread starter Thread starter Kammam
  • Start date Start date
K

Kammam

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.
 
If all you want is the numbers from A1, B1 and C1 in D1 separated by
dashes...

=A1&"-"&B1&"-"&C1
 
CONCATENATE() is the function to combine text strings.

Alternatively you can use teh ampersand &

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

If this post helps click Yes
 
Back
Top