Re: [libreoffice-users] Inserting user first and last name into a cell in Calc

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 <brucehohl@gmail.com> 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 <john.l.meyer@gmail.com>
> 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: users+unsubscribe@global.libreoffice.org
> > 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: users+unsubscribe@global.libreoffice.org
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