Re: How to merge 2 columns into 1?
John Denker via gnumeric-list <[email protected]> Mon, 19 Aug 2019 13:45:50 -0700
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <[email protected]> |
On 8/19/19 1:09 PM, bill wrote: > 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? If necessary, format numbers using the text(,) function. https://support.office.com/en-us/article/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c Combine formatted results using the "&" operator or, equivalently, the concat(...) function. If that's not what's wanted, please ask a more specific question. Explain what you tried, and why it wasn't satisfactory.