Previous Topic Next Topic

Macros 2 columns info into 1 same wksht.

Closed
Derek - Nov 13, 2011 at 08:17 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 13, 2011 at 11:10 PM
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?

Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 13, 2011 at 11:10 PM
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.
0