Question: . The first task is to apply the text manipulation skills from CH 5 to break up column B into County and State. Insert three
The first task is to apply the text manipulation skills from CH to break up column B into County and State. Insert three columns after column B and follow the instructions below: a Column C: use the FIND function to find the location of comma in column B b Column D: use LEFT and other functions to extract only county name from column B Make sure a the functions reference column C and b there is no leading and trailing space in the result. c Column E: use RIGHT and other functions to extract only state name from column B Make sure a the functions reference column C and
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
