Merging Columns

[sanpanza]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Hi, I am tryng to merge columns such that in column I have have 100 rows of first names and in column B I have one hundred rows of Last Names. I want one column with 100 rows of "first names" space "last names".

Can anybody show me where I can find out how to do this please. Much obliged.

 

[CyberTaz]

Yes, this can be done, but please forgive me for questioning the wisdom of
doing so. Typically, combining 2 separate data items in a single field
causes nothing but limitations & constraints on how the data can be used.
Sorting, filtering, data merge, etc. all suffer from such a method. If you'd
describe your purpose perhaps there is a different approach that would be
more practical.

If you do have a real need to combine the data I'd suggest:

1- In C1 (or whatever) either of these formulas;
=CONCATENATE(A1," ",B1) or =A1&" "&B1

2- Copy the formula down the necessary number of row

3- While the cells are still selected, copy them then use Edit> Paste
Special - Values to replace the formulas with the combined first & last
names they provided.

HTH |:>)
Bob Jones
[MVP] Office:Mac