Re: How to merge 2 columns into 1?

Richard T Bumby <[email protected]> Mon, 19 Aug 2019 16:39:46 -0400

Newsgroups	gmane.comp.gnome.apps.gnumeric
Message-ID	<[email protected]>

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&amp;data=02%7C01%7Cbumby%40scarletmail.rutgers.edu%7Caaae487d215c49f3bd7e08d724e11c5c%7Cb92d2b234d35447093ff69aca6632ffe%7C1%7C0%7C637018421581428840&amp;sdata=Hl8CdOvDdLnW%2FxkBk5%2FoazsMnWx2AyHyVUiJQHkvHxo%3D&amp;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