Formula – odvoji imena i prezimena u posebne ćelije

22/06/2013 § Leave a comment

Extract First Name from Full Name

=LEFT(A1,FIND(” “,A1)-1)

Extract Last Name from Full Name

=RIGHT(A1,LEN(A1)-FIND(” “,A1))

 


Source:

http://www.bluemoosetech.com/microsoft-excel-functions.php?jid=32

http://www.extendoffice.com/documents/excel/829-excel-split-first-last-name.html

http://excelhints.com/2009/01/24/separate-full-name-into-first-last-name/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading Formula – odvoji imena i prezimena u posebne ćelije at RheXenoR.

meta

%d bloggers like this: