Formula needed

  • Thread starter Thread starter Sal Iaccarino
  • Start date Start date
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
 
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
 
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...
 
Back
Top