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

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.
 
R

Rick Rothstein

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

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

Jacob Skaria

CONCATENATE() is the function to combine text strings.

Alternatively you can use teh ampersand &

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

If this post helps click Yes
 

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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Combining Text From Cells 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
How to convert the values into 3 digits? 5
Combine multiple cells (3) adding a Colon (:) 4
How to Combine two cells (numbers) but not add 7
formatting formula help!!! 1
How to combine two different excel files 1

Top