Forum Discussion

CaffeineKing's avatar
CaffeineKing
Copper Contributor
Mar 22, 2019
Solved

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...
  • SergeiBaklan's avatar
    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.

     

Resources