Question: Now that we have the first name ( along with the comma and space ) , let's tweak the starting position to clean up the
Now that we have the first name along with the comma and space let's tweak the starting position to clean up the output.
You will want to add two to the starting position, which is being found by the SEARCH function. This moves the starting position to the right.
Modify your previous MIDa SEARCH a formula to just get the first name.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
