Just expand the formula, and move the formula over so that it always ends up in an empty cell.

If you're not sure how many you're going to need, you could put the formula into column A and your data into columns B->?

Using this, for 3 it'd be =B1&" "&C1&" "&D1

For 4: =B1&" "&C1&" "&D1&" "&E1

For 5: =B1&" "&C1&" "&D1&" "&E1&" "&F1

etc.

thanks,

Statistics: Posted by UniSET — Mon Oct 13, 2014 12:11 pm

]]>

To merge multiple rows at a time, First pair of names in A1 and B1,

C1 =A1&" "&B1

copy down C1

thanks,

Statistics: Posted by Ricky G. Marion — Mon Oct 13, 2014 11:53 am

]]>

Is there a way to merge multiple rows at a time while keeping the row values separate ?

For example, I want to merge the following:

Row 1: Jennifer | Johnson

Row 2: Dan | Paulson

into

Row 1: Jennifer Johnson

Row 2: Dan Paulson

The only way I can see to do this right now is to highlight each individual row and merge it separately.

Is there a better way to do this ? Can I do this with multiple rows at once? Or a better way?

Thanks,

Statistics: Posted by Micheal T. Leo — Sat Oct 11, 2014 4:59 am

]]>