How to Separate Names/Data in an Excel Column

I want to demonstrate in this article how you can separate the first name from a column with full names in it. This is a question we receive quite often. You can do this by using the SEARCH function.

How to Separate Names/Data in an Excel Column.

The first step is to create a column with full names.

Now select the cells B2:B15

And type in the following formula =LEFT(A2;SEARCH(" ";A2)-1)

And hit CTRL+ENTER

And that’s it. Now you know how to separate names and data in an Excel column.