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 CH5 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 function(s) 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 function(s) reference column C, and (

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!