This is an Excel problem for Accounting Systems: Use a fuction in excel to separ

Question

This is an Excel problem for Accounting Systems:

Use a fuction in excel to separete the First and Last name and exclude the middle name or initial

Employee ID Employee Name Last Name First Name 00002582 DIEDRICH,aaron 00002671 BAKER,aaron d 00002993 GOSLOVICH,aaron gene 00004018 PEREIRA,aaron gene 00004054 MINCHAK,aaron j 00004125 SCHOENBAUM,aaron j 00004321 FISHMAN,aaron m 00004544 HUBER,aaron michael 00004973 NOYCE,aaron s 00005017 FAULKNER,aasa e dahlberg 00005071 DANILA,abdullahi y 00005482 ZICOPULA,abigail e 00005785 CONVERY,abigail l 00006356 CARROLL,adam e 00006606 COLVIN,adam j 00006793 CONOCCHIOLI,adam s 00006802 NEGUS,adam s 00007239 POPP,adam w 00007792 MCADAMS,adesegun a 00008032 NYE,adrian c 00008194 GOLDMAN,adrienne e 00008531 COGAN,adrienne m 00008951 NELSON,agnes t 00009512 KANE,aislinn 00009923 FILARDO,ajmer 00010325 HILLER,alan e 00010753 ROMAINE,alan e 00010799 HEIDEL,alan ervin 00010833 HUSTED,alan ervin 00010959 HIENDLMAYR,alan g 00011242 DEMATTOS,alan j 00011404 GARSHELIS,alan p 00012018 TERHAAR,alan r

Explanation / Answer

Formula for first Name: =MID(A2,SEARCH(" ",A2,1)+1,SEARCH(" ",A2,SEARCH(" ",A2,1)+1)-SEARCH(" ",A2,1))

Formula for last name =LEFT(A2, SEARCH(" ",A2,1)-2)

Considering that the name is in A2 Cell

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.