consolidation of adjacent columns

  • Thread starter Thread starter rooniwife
  • Start date Start date
R

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
 
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


|
| 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?action=getinfo&userid=24904
| View this thread: http://www.excelforum.com/showthread.php?threadid=384425
|
 
Thanks ScottO,
I had tried what you suggested before but I guess that my spaces wer
not in the right place....
Now is there an easy way to to this for a gazillion entries in bot
columns without having to enter the formula each time???

Thanks,
rooniwif
 
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

|
| 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?action=getinfo&userid=24904
| View this thread: http://www.excelforum.com/showthread.php?threadid=384425
|
 
Back
Top