Threezs
asked on
How to merge text in cells quickly and easily in EXCEL.
Hi,
I am using excel to create a csv file for shopify. I need to be able to merge text inside of cells quickly with a simple cut and paste, drag and drop etc. As you can see in the attached file, I would like to be able to merge columns B through G. In this case 1984 to the name of the player. The problem, is that there are over 800 products in that csv file and I will be uploading 10's of thousands more to a website. I can easily gather the player's name and number but I need to find a way to combine that quickly with the other details like Topps, 1984, Baseball, etc quickly. There must be a program out there that can do that. Or how do I do it myself without creating a 10 mile long excel equation. I have attached a sample excel spreadsheet so you can see what I am referring to. Thanks!
Book1.xlsx
I am using excel to create a csv file for shopify. I need to be able to merge text inside of cells quickly with a simple cut and paste, drag and drop etc. As you can see in the attached file, I would like to be able to merge columns B through G. In this case 1984 to the name of the player. The problem, is that there are over 800 products in that csv file and I will be uploading 10's of thousands more to a website. I can easily gather the player's name and number but I need to find a way to combine that quickly with the other details like Topps, 1984, Baseball, etc quickly. There must be a program out there that can do that. Or how do I do it myself without creating a 10 mile long excel equation. I have attached a sample excel spreadsheet so you can see what I am referring to. Thanks!
Book1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.