Homework SourseThis is an Excel problem for Accounting Systems Use a fuctio
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 |
Solution
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
