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
 
Back
Top