>> Have a huge users list with the form <'lastname', 'middle-name' >> 'first-name'>. I need to extract initials and I can't figure out how >> to do that. >> Following the example, expected result should be <mflastname> >> Any clue? > > If the first three columns (A-C) are 'lastname' (A), 'middle-name'(B), > and 'first-name(C) and column D contains that the initials plus the last > name, the equation for this is: =CONCATENATE( LEFT(B1),LEFT(C1),A1).
that's why I love LibO, things are easier than what we can see some users --~--~---------~--~----~------------~-------~--~----~ Escuelas Libres :: Porque la educación es mucho mejor cuando es libre www.escuelaslibres.org.ar --- LiberTICs Cooperativa Ltda. www.libertics.com.ar --- Para entrenar, cualquier programa sirve. Para educar, sólo Software Libre. (Federico Heinz) --- -- For unsubscribe instructions e-mail to: users+h...@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