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

[newbie78]

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"

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.

 

[VoG]

Try this:

Excel Workbook
	A	B	C
1	Item number	Description
2	19035	Cashew 40 Gms	19035: Cashew 40 Gms
Sheet12

 

[newbie78]

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]

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]

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.

 

[newbie78]

Yep... that works perfect. Thanks for your Help!!