Column B has unformatted student names. Some names have spaces in front of their first name or more than one space between names. Update the output cells so that each row in column C displays TRUE if after removing extra spaces, the employee name in column B contains exactly two words. Otherwise display FALSE. For instance, the raw name " BOB BROWN " after removing extra spaces would be just "BOB BROWN". See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
This cell cannot be edited
Column B has unformatted student names. Some names have spaces in front of their first name or more than one space between names. Update the output cells so that each row in column C displays TRUE if after removing extra spaces, the employee name in column B contains exactly two words. Otherwise display FALSE. For instance, the raw name " BOB BROWN " after removing extra spaces would be just "BOB BROWN".