Using RIGHT and LEFT string functions in Excel


Just sharing a simple example of using the RIGHT and LEFT functions to extract the required content from a particular column.

E.g. we want to extract the name (FirstName, LastName, Mobile) from the below column in the Excel

Here we can apply RIGHT(text, [num_chars]) function to first remove the characters

<xs:element name=” i.e. 18 characters

And then LEFT(text, [num_chars]) function to remove the remaining

” type=”xs:string”/> i.e. 20 characters

=RIGHT(A1:A3, LEN(A1:A3) -18)


Output –


=LEFT(B1:B3,LEN(B1:B3)-20)


Output –


The LEN(text) function gets the length of the text

Hope this helps..

Advertisements

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

One thought on “Using RIGHT and LEFT string functions in Excel”

Please share your thoughts

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.