Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In column E , use the appropriate text function to return the position of the comma character located in the data in column D .
In column E use the appropriate text function to return the position of the comma character located in the data in column D Copy the formula down through cell E Hint: Do not use the optional argument
In column F use the appropriate text function to return to the length of the text in column D Copy the formula down through cell F
In column G use the appropriate text function to extract only the last name from column D Copy the formula down through cell G Hint: Do not use nested functions
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started