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 does not accept text format! 0
Cell data entering slow! 0
Split cells next to 1 cell 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
If then formula with multiple cells 2
Merging from an Excel file with graphics 1
Space at end of multi page list to accommodate new entries 1
Threshold Equation Help 0

Top