Merging multiple cells with data

[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?)

 

[Dan B]

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