Use find and replace to clean up inconsistent data.
Replace "M" with "Male" and "F" with "Female" in the Gender column
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| # | ID | Full Name | Email | Phone | City | Gender |
| 1 | 1 | John Smith | john.smith@email.com | 555-1234 | New York | M |
| 2 | 2 | Maria Garcia | maria.g@email.com | 555-2345 | Los Angeles | F |
| 3 | 3 | Robert Johnson | robert.j@email.com | 555-3456 | Chicago | M |
| 4 | 4 | Emily Brown | emily.b@email.com | 555-4567 | Houston | F |
| 5 | 5 | Michael Davis | michael.d@email.com | 555-5678 | Phoenix | M |
| 6 | 6 | Sarah Wilson | sarah.w@email.com | 555-6789 | Philadelphia | F |
| 7 | 7 | David Lee | david.l@email.com | 555-7890 | San Antonio | M |
| 8 | 8 | Jennifer Martinez | jennifer.m@email.com | 555-8901 | San Diego | F |
| 9 | 9 | James Taylor | james.t@email.com | 555-9012 | Dallas | M |
| 10 | 10 | Lisa Anderson | lisa.a@email.com | 555-0123 | San Jose | F |
| 11 | 11 | John Smith | john.smith@email.com | 555-1111 | Boston | M |
| 12 | 12 | Maria Garcia | maria.g@email.com | 555-2222 | Miami | F |