Extracting first name from one column to another

O

Orla

I have a colum with the full name of a person. I want to create another
column whereby I have only the first name. Which function do I need to
use ? Thanks!
 
C

Corran Horn

I have a colum with the full name of a person. I want to create another
column whereby I have only the first name. Which function do I need to
use ? Thanks!
Click to expand...

=left(A1;search(" ";A1)-1)

CoRrRan
 
Top