Free practice · Hands-on spreadsheet · medium

Practice

Clean a customer code

In C2, remove extra spaces from B2 and convert the cleaned customer code to uppercase.

Sales spreadsheet
RowABC
1
2
3
4