I'm actually referring to the first name and last name recorded in document properties for LibreOffice. You can insert them in Writer by using the appropriate fields. However, I can't find any sort of function that would do the same thing for Calc.
On Sat, May 7, 2016 at 8:25 AM, Bruce Hohl <[email protected]> wrote: > If you have a reference to the name like an ID column you could use > vlookup() > Like this: =concatenate( vlookup(), " ", vlookup() ) > Or this: =vlookup()& " " & vlookup()) > See Help for vlookup syntax. > > On Sat, May 7, 2016 at 10:15 AM, John Meyer <[email protected]> > wrote: > >> I'm trying to find a way to insert a user's first and last name as defined >> in the user date into a cell in a spreadsheet. Is there a function that >> will let me do that? >> >> Thanks. >> >> -- >> To unsubscribe e-mail to: [email protected] >> Problems? >> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >> List archive: http://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived and cannot be >> deleted >> > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
