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.

jcc31 wrote:

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.

--
jcc31
------------------------------------------------------------------------
jcc31's Profile: http://www.excelforum.com/member.php...o&userid=24692
View this thread: http://www.excelforum.com/showthread...hreadid=490871

--

Dave Peterson