Special Paste Value

[jcc31]

Hi,
Does anybody know how to make a macro that will do the following?
Do a special paste value with Column B and Column C and Column D.
Column B = I
Column C = Love
Column D = You
So Column B comes out "I Love You"
But I would like to this with all of my rows in these columns.

I was thinking something like this
hard code this formula =B2&" "&C2&" "&D2
copy this code
and then special paste value this code into all the rows. Of course
all rows will be different text

 

[Dave Peterson]

How about inserting a new helper column (I'd use D).

Then put that formula in D2 and drag down.

Then select D and edit|copy
select B and edit|Paste special|values
delete that helper column D.

You could even record a macro when you do it once, if you need it mechanized.