Formula needed

S

Sal Iaccarino

I have;
Abraham, Isaac & Michael

I am able to obtain using formula:
Isaac & Michael

Require a formula to extract:
Abraham

Thanks in advance,

Sal and Eileen
 
J

JulieD

Hi Sal & Eileen

if your data is always structured the same you can use either the Data /
Text to Columns feature to split it up into different columns or if really
only want to extract the surname part then
=LEFT(A1,FIND(",",A1)-1)
should give you what you're after

Regards
JulieD
 
S

Sal Iaccarino

JulieD,
Thank you very much!
Sal and Eileen
JulieD said:
Hi Sal & Eileen

if your data is always structured the same you can use either the Data /
Text to Columns feature to split it up into different columns or if really
only want to extract the surname part then
=LEFT(A1,FIND(",",A1)-1)
should give you what you're after

Regards
JulieD
Click to expand...
 

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

Ascertain Unique value considering Two columns 1
Text Functions, 8
Sub-Totalling Based upon a changing field 1
copying only selected data from Sheet 1 to Sheet 2 2
Multiple templates with common styles 2
Copy addition formula of non-consecutive horizontal cells 2
COPYING FORMULAS 3
Using <= in countifs statement 1

Top