Forum Discussion
CaffeineKing
Mar 22, 2019Copper Contributor
Merge Cells with Different Data Types
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...
- Mar 22, 2019
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.
SergeiBaklan
Mar 22, 2019Diamond Contributor
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.
- CaffeineKingMar 22, 2019Copper ContributorThank you friend!