Re: How to merge 2 columns into 1?



On 8/19/19 4:09 PM, bill wrote:
Hi all,
I need to merge the text of 2 columns into 1 with a space between them. The examples i find online dont seem to work for gnumeric. Can anyone offer suggestions? Many thanks!
peace
peace
bill
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://nam02.safelinks.protection.outlook.com/?url="">

My method:

In C1 enter: =A1&" "&B1

(usually the cells are entered using the mouse, but the keyboard can also be used)

propagate this formula to the rest of the column.  If you just want to keep the result, copy column C and use paste special/value to put it where you want it.

--RTB




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]