=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 . <s...@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+unsubscr...@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+unsubscr...@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