Merging multiple cells with data

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

How can I merge cells (all containing data) and not lose
any entered data? (ex. I have 3 columns of data - part
numbers - and combined each row equals one actual part
number...how do I combine to make the part number without
having to retype all the numbers?)
 
Assuming that your part numbers you want to join are in columns A and B, the
formula you would put in column C is =A1&B1 If you need spaces or dashes
added in you would need to add that to the formula. If so, post back.

Dan
 

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

vlookup with merged cells 1
Convert number to text as displayed 3
Excel Need Countifs Formula Help 0
How to count merged cells 1
Counting Merged Cells 5
Copy non merged to merged cells 2
Help With Formula For Cell Addresses 2
Copy paste non merged to merged cells 1

Back
Top