whats the formula B4 X V fx A B C D E F G H K In cells B4 and C4,...

Image transcription text

B4 X V fx A B C D E F G H K In cells B4 and C4, write formulas that extract the the first name and the last name from the corresponding value in column A that includes first, middle, and last name. First name Last name Mary May Robin Mary Robin You may assume a single space " " separates each two Larry Smith King Larry King words. Mike Ming Liu Mike Liu Ahmed MD Rafik Ahmed Rafik Write the formulas so that they can be autofilled/copied from B4/C4 to B7/C7. You must NOT create extra values to be stored in additional columns or rows. A screenshot of the solution has been provided. N 3 First name Last name 4 Mary May Robin 5 Larry Smith King 6 Mike Ming Liu 7 Ahmed MD Rafik 8

... Show more

whats the formula