Close
Social profiles

The Excel formula RIGHT function extracts a given number of characters from the right side of a supplied text string. 

The Excel formula LEFT function extracts a given number of characters from the left side of a supplied text string.

Extract First Name from Full Name

The following formula will extract the First Name from the Full Name

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

Extract Last Name from Full Name

To get the last name from the full name, The following formula will extract the Last Name from the Full Name

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

You can check more about this topic by accessing Excel or LibreOffice Categories.

Leave a Reply

Your email address will not be published. Required fields are marked *

Close