SOLVED
Home

Merge Cells with Different Data Types

%3CLINGO-SUB%20id%3D%22lingo-sub-382792%22%20slang%3D%22en-US%22%3EMerge%20Cells%20with%20Different%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382792%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20columns%20with%20many%20rows.%3C%2FP%3E%3CP%3EIn%20the%20left%20column%2C%20load%20ratings%20for%20tires.%20In%20the%20right%20column%2C%20the%20speed%20ratings%20for%20those%20tires.%3C%2FP%3E%3CP%3EI%20need%20to%20copy%20this%20info%20into%20another%20spreadsheet%2C%20but%20for%20the%20client's%20convenience%20it%20needs%20to%20be%20one%20column.%3C%2FP%3E%3CP%3ESince%20I%20have%20well%20over%20four-hundred%20entries%2C%20I%20was%20hoping%20there%20was%20an%20easier%20way%20to%20merge%20these%20cells%20so%20I%20can%20just%20copy%2Fpaste%20into%20the%20new%20spreadsheet%20instead%20of%20typing%20it%20out%20manually.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20clarify%2C%20the%20left%20column%20contains%20integers%20and%20the%20right%20column%20contains%20letters%2C%20can%20I%20consolidate%20the%20data%20into%20one%20column%3F%20(Example%3A%20113%20and%20S%20--%26gt%3B%20113S)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-382792%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ehelp%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382798%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%20Cells%20with%20Different%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382798%22%20slang%3D%22en-US%22%3EThank%20you%20friend!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382797%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%20Cells%20with%20Different%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382797%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F299427%22%20target%3D%22_blank%22%3E%40CaffeineKing%3C%2FA%3E%26nbsp%3B%2C%20in%20next%20column%20you%20may%20use%20formula%20like%3C%2FP%3E%0A%3CPRE%3E%3DA1%20%26amp%3B%20B1%3C%2FPRE%3E%0A%3CP%3Edrag%20it%20down%20till%20end%20of%20you%20range%20(or%20select%20till%20end%20of%20the%20range%20and%20Ctrl%2BD).%20Copy%20that%20column%20and%20Paste%20as%20values%20into%20new%20sheet.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
CaffeineKing
New 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
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!