Copying content of 1 Cell and adding that to content of 2nd cell

newbie78

New Member
Joined
Aug 7, 2010
Messages
20
I have a price list which I am trying to create in excel which will eventually be imported into point of sale software. However, the product list which I have from my supplier has 2 Columns right now.

Col A- Item Number
Col B- Item Description

Now what I want is to copy the content of Col A and Edit content for colB and add so now the content of col B will be "Item# : Description"

HTML:
Original Data:

Col A: 19035
Col B: Cashew 40 Gms

Edited Data to look as follows:

Col A: 19035
Col B: 19035: Cashew 40 Gms

I need the above done to the whole worksheet for all items. Can someone please help!!

I am using Excel 2007. And thanks in advance.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

newbie78

New Member
Joined
Aug 7, 2010
Messages
20
Thank you sir... that was quick, easy and simple!! Let me try and see if my Point of Sale software likes it.. because after the excel is done.. I will have to use it to import items into my Point of sale software.. I hope it work!! But thanks for your quick reply!!
 

newbie78

New Member
Joined
Aug 7, 2010
Messages
20
I tried the formula which you suggested. However, I have a pre defined template which is to be used for importing items to my Point of Sale software. Now when I entered the formula in my original worksheet it works fine. But when I try to copy the cells from my original worksheet and paste it in the template provided by my POS software it shows #REF#REF on the cells. Any suggestions??
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Select your column of concatenated values. On the Home tab click Copy. Then click the black arrow at the bottom of the Paste button, select Paste Special, tick Values and click OK.
 

Forum statistics

Threads
1,176,402
Messages
5,902,850
Members
435,001
Latest member
ahsanali32

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top