In the previous post, we learnt about how to compare two strings (Case sensitive and Case insensitive) in Excel. In this post, we shall learn how to separate string from a specific character in Excel.
Let's take example of below data.
In B column we have Full Name of people separated by Comma (,). We need First Name and Last Name seprately into two different columns.
To get First Name, we have written '=LEFT(B3, (FIND(",",B3) - 1))' formula in C3 cell that
The same formula has been copied to other C column cells that gives above result.
To get Last Name, we have written '=RIGHT(B3,LEN(B3)-FIND(",",B3)-1)' formula in D3 cell that
The same formula has been copied to other D column cells that gives above result.Views: 571 | Post Order: 27