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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Want to test if Full Name is NOT Present in document 0
Mail Merge Directory Conditional Page Break 0
Crating User Form to Add Names 1
Weekly Report 2
MS Project Center-Autolink column fields 0
Grouping Names in Mail Merge 0
Merging from an Excel file with graphics 1
How to center adjust text above and image in a two column document. 1

Top