SpLiT nAmE

This formula is related to the separation of the first name and the last name in different cells. We generally write the name with its surname in the same cell.

To make data in single cell is not a issue we can change it according to our requirements. By applying this simple formula

• Below you can see a name in a cell. Now select the data tab. In the data tab select text to columns.

• Now select fixed width. And press next. 

• Then press next again.

• Then press finish.
• Now you can see the first and last name in different cell.

• And our next formula is related to change the name in single cell. 

• For this we have to apply

          =CONCATENATE (Select First Name , last name).

• And from two different cell the name is converted into single cell. And you can drag the whole column.