Re: How to merge 2 columns into 1?
- From: John Denker <jsd av8n com>
- To: bill <bill samerica com>, gnumeric-list gnome org
- Subject: Re: How to merge 2 columns into 1?
- Date: Mon, 19 Aug 2019 13:45:50 -0700
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.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]