SOLVED

Merge Cells with Different Data Types

Copper Contributor

I have two columns with many rows.

In the left column, load ratings for tires. In the right column, the speed ratings for those tires.

I need to copy this info into another spreadsheet, but for the client's convenience it needs to be one column.

Since I have well over four-hundred entries, I was hoping there was an easier way to merge these cells so I can just copy/paste into the new spreadsheet instead of typing it out manually. 

 

To clarify, the left column contains integers and the right column contains letters, can I consolidate the data into one column? (Example: 113 and S --> 113S)

2 Replies
best response confirmed by CaffeineKing (Copper Contributor)
Solution

@CaffeineKing , in next column you may use formula like

=A1 & B1

drag it down till end of you range (or select till end of the range and Ctrl+D). Copy that column and Paste as values into new sheet.

 

Thank you friend!
1 best response

Accepted Solutions
best response confirmed by CaffeineKing (Copper Contributor)
Solution

@CaffeineKing , in next column you may use formula like

=A1 & B1

drag it down till end of you range (or select till end of the range and Ctrl+D). Copy that column and Paste as values into new sheet.

 

View solution in original post