Extracting first name from one column to another

  • Thread starter Thread starter Orla
  • Start date Start date
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!
 
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
 
Back
Top