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
[email protected]
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmail.gnome.org%2Fmailman%2Flistinfo%2Fgnumeric-list&data=02%7C01%7Cbumby%40scarletmail.rutgers.edu%7Caaae487d215c49f3bd7e08d724e11c5c%7Cb92d2b234d35447093ff69aca6632ffe%7C1%7C0%7C637018421581428840&sdata=Hl8CdOvDdLnW%2FxkBk5%2FoazsMnWx2AyHyVUiJQHkvHxo%3D&reserved=0
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
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
