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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,579
Messages
5,659,629
Members
418,517
Latest member
LordWiader

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