On 10/04/2012 02:23 PM, Daniel A. Rodriguez wrote:
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?
--~--~---------~--~----~------------~-------~--~----~
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)
---
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).
--Dan
--
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
