Multiple worded cell contents put into one cell

microsoft-excel google-spreadsheets

if you are using Office 2019/365, please try this:

=TEXTJOIN("+",1,IF(B1:B5>1,A1:A5,""))

enter image description here

Related

Why do we use redsocks+iptables instead of using iptables only?
Copy / restore files from Time Machine Backup Volume without Permission Denied Error
Docker get a list of possible environment variables
FTP Transfers keep asking me about existing files even when they are not
Improve FFmpeg and NVENC output quality
VeraCrypt volume does not decrypt - lost the password. Error message: "Source: MountVolume:8299"
Why is iperf3 faster in one direction than the other?
Display certain values in excel if criteria is met
How is it possible for lightdm to auto login without using a tty?
Why does video conversion lower quality so much?
determining a linux filesystem drive types in powershell for automounting
MacOS Big Sur none of the start up keys are working