I have 150 names, in two columns: Last Name , First Name. I want them in one column. I can do this with merge cells, but merge will only do one pair at a time. How do I do all 150 names at once, without all of the names winding up in a single cell, which is useless.
Merging cells is mostly evil. Doing it for this purpose is so specifically. Don’t think of the solution by @Edward3 as being a workaround. It is the solution - the Copy / Paste Special omitted…
Additional remark
Keep also the unconcatenated data!
One day you may want to concatenate them in the revers order? Add a third and fourth part? Prefix a title? …
Having the data only in concatenated form enhancements may get a nightmare.
(Whether you use the CONCATENATE function or the concatenation operator & is an arbitrary variation. For the concatenation of more than 2 parts of which some may be empty, also the more recently implemented TEXTJOIN may be the tool of choice.)
Possible workaround, you could use the CONCATENATE function =CONCATENATE(A1," ",B1) to report the combined names in Column C (or any other column), and then copy the formula down all 150 rows. You can then copy the results to another sheet or even overwrite back to Column A (use “Paste Special” or “Paste Only” to copy only the results but not the formula).
Arguments inside parentheses are separated by semicolons.
Hi
Other solution:
-
CopythenEditâ–¸Paste Unformatted Textin writer - Copy then paste from Writer to Calc.
Regards
You want merge A and B column to C column
go to first cell from C column an type C1=A1&" "&B1
then enter
then go to right corner cross , double click and fill all the C column
or copy the C1 cell to all ohers Cells you want to merge
1 Like