copy text from one cell to another in one sheet

@Jörg Schmidt Novum Hospitality

Happy to help!

Try this.

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Wartung];
[Anlass Allgemeine Anfrage]:[Anlass Wartung];@cell <>""); CHAR(10))

Did that work?

All comments

Are you able to provide a screenshot with mock data manually entered that shows what you are trying to accomplish?

Anlass.png

Hi @Jörg Schmidt Novum Hospitality

I hope you're well and safe!

I'm not sure I follow.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Try something like this...

=JOIN(COLLECT([Column 1]:[Column 2]; [Column 1]:[Column 2]; @cell <> ""); CHAR(10))

Hi Paul,

could you check my entry once please. I still get "unparseable" as result ;-)

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben]:[Anlass Brandschutz];@cell <>); CHAR(10)) 🤔😏

Hi @Jörg Schmidt Novum Hospitality

Try something like this.

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben];
[Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben];@cell <>""); CHAR(10))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Hi Andree,

it works with the 2 topics. But why does it not work with 4 topics ?

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben]:[Anlass Brandschutz]:[Anlass Wartung]; [Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben]:[Anlass Brandschutz]:[Anlass Wartung]; @cell <> ""); CHAR(10))

Thank you

@Jörg Schmidt Novum Hospitality

Happy to help!

Try this.

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Wartung];
[Anlass Allgemeine Anfrage]:[Anlass Wartung];@cell <>""); CHAR(10))

Did that work?

Hi Andree,

thanks for your help.

Currently, I cannot see the difference between you first and second proposal ?

Could you explain it to me ?

kind regards Joerg 😃

Hi,

happy to have found explanation on myself right now

Now, it works. Phantastic.

Thanks to both of you - Paul and Andree - for helping again.

You are great 😁

@Jörg Schmidt Novum Hospitality

Excellent!

You're more than welcome!

To answer your question. The ranges have to match.

=JOIN(COLLECT([Column 1]:[Column 4];
[Column 1]:[Column 4];@cell <>""); CHAR(10))

Make sense?

Dear Andree, dear all,

unfortunately, I have to reopen this issue. Somehow, it does not work properly, yet. Pls see screenshot.😏

I use:

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Trinkwasserhygiene]; [Anlass Allgemeine Anfrage]:[Anlass Trinkwasserhygiene]; @cell <> ""); CHAR(10))

2021-08-04 Fehlermeldung helper.png

Try using "@row" references to only reference the row the formula is on.

=JOIN(COLLECT([Anlass Allgemeine Anfrage]@row:[Anlass Trinkwasserhygiene]@row; [Anlass Allgemeine Anfrage]@row:[Anlass Trinkwasserhygiene]@row; @cell <> ""); CHAR(10))

Also make sure that the wrap text functionality is turned on for the column the formula is on.

Hi Paul,

nice to hear from you. Hope you are fine ?

What does it mean?

"Also make sure that the wrap text functionality is turned on for the column the formula is on."

and how can I make sure that the formula works when a new line has been built after sending data by a form?😏