consolidation of adjacent columns

[rooniwife]

Please tell me how to merge two adjacent columns with a space between them. Both columns contain text and numerals.
For example:

212 by Carolina Herrera EDT SPRAY 1.7 OZ

Thank You,
rooniwife

www.spotajavacoffee.com

[ScottO]

If A1 contains "212 by Carolina Herrera", and B1 contains "EDT SPRAY 1.7 OZ", then put this formula
in C1 ...

=A1&" "&B1
(Note that there is a space between the quote marks in the formula.)

Rgds,
ScottO


"rooniwife" <rooniwife.1roc6b_1120529110.6178@excelforum-nospam.com> wrote in message
news:rooniwife.1roc6b_1120529110.6178@excelforum-nospam.com...
|
| Please tell me how to merge two adjacent columns with a space between
| them. Both columns contain text and numerals.
| For example:
|
| 212 by Carolina Herrera EDT SPRAY 1.7 OZ
|
| Thank You,
| rooniwife
|
| www.spotajavacoffee.com
|
|
| --
| rooniwife
| ------------------------------------------------------------------------
| rooniwife's Profile: http://www.excelforum.com/member.php...o&userid=24904
| View this thread: http://www.excelforum.com/showthread...hreadid=384425
|

[rooniwife]

Thanks ScottO,
I had tried what you suggested before but I guess that my spaces were not in the right place....
Now is there an easy way to to this for a gazillion entries in both columns without having to enter the formula each time???

Thanks,
rooniwife

[ScottO]

If the formula that you want to copy down is in a column right beside one of the data columns, and
there's no blank cells in that column of data, then do this ...
1. Select the cell with the formula
2. Double-click on the "fill handle"

The "Fill Handle" is the small black square in the bottom right corner of the selection border.

Rgds,
Scott

"rooniwife" <rooniwife.1rpnef_1120590316.8173@excelforum-nospam.com> wrote in message
news:rooniwife.1rpnef_1120590316.8173@excelforum-nospam.com...
|
| Thanks ScottO,
| I had tried what you suggested before but I guess that my spaces were
| not in the right place....
| Now is there an easy way to to this for a gazillion entries in both
| columns without having to enter the formula each time???
|
| Thanks,
| rooniwife
|
|
| --
| rooniwife
| ------------------------------------------------------------------------
| rooniwife's Profile: http://www.excelforum.com/member.php...o&userid=24904
| View this thread: http://www.excelforum.com/showthread...hreadid=384425
|

[rooniwife]

thanks a bunch scotto
rooniwife