Macros 2 columns info into 1 same wksht.

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I have two columns of information. One column is labeled description and lists a (numerical and text) description of and item. EX: 1/2" x 3/4" copper fitting.

In the second column the price is listed for that item.

Both items are on the same worksheet and I would like to combine the desription and the price into one cell creating a new column with both description and price.

I am a novice at marcos and could use some serious help! Can anyone facilitate my need?

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
no need a macro

suppose sample data like this

name price
1/2 copper 1
2 silver 2
3 3
4 4
5 5
then in C2 copy paste this formula

=A2&" "&B2
copy C2 down.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!