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