🕑 Quiz time: In cell A2, you have the messy string " @MaRy - LOU ". It contains extra spaces, a special character (@), a dash separating the first and last name, and inconsistent capitalization. Your goal is to clean the text and return a properly formatted full name: Mary Lou.
Question: Which formula correctly cleans and formats the name?
Simon Sez IT
🕑 Quiz time: In cell A2, you have the messy string " @MaRy - LOU ". It contains extra spaces, a special character (@), a dash separating the first and last name, and inconsistent capitalization. Your goal is to clean the text and return a properly formatted full name: Mary Lou.
Question: Which formula correctly cleans and formats the name?
4 months ago | [YT] | 28