Fwd: [libreoffice-users] Calc- combine columns data

=concat(a1," ",a2)

So A1 = Mark, A2 = Smith, A3 will be Mark Smith
If A1 is Mike and A2 is empty, A3 will be Mike

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Fri, Dec 2, 2022 at 7:07 AM . <SE@shch262.com> wrote:
> I want to be able to combine the contents of, say, column A into column
> B without losing data in any of the rows.
>
> Each column have blanks in certain rows so the data wont be overwritten.
>
> Example;  A1 has data but B1 doesn't
>
> A2 has no data but B2 does
>
> Can this be done?
>
> Thanks,
>
> Peter
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy