To complete this task, please download the PracticeExcelSheet_F from here.
The first column on the worksheet NameSurname contains clients’ names and surnames as entered on an online form.
As you can see, there are several issues, including extra spaces and inconsistent formatting. Use the appropriate functions to complete the following tasks:
Remove any spaces before and after the text. Enter your answer in column B.
In column C, capitalise the first letter of the name and surname while keeping the remaining letters in lower case.
In column D, convert the name and surname to lower case.
Convert the name and surname to upper case and enter the result in column E.
In columns F and G, add the greetings as indicated in the respective column headings.
Barcodes are coded strings made up of different sections, where each section represents specific information such as the country, manufacturer and product. On the worksheet Barcode, complete the following tasks:
Extract the first three characters, which represent the country code. Enter your answer in column B and include a heading in cell B1.
Extract the next four characters, which represent the manufacturer code. Enter your answer in column C and include a heading in cell C1.
Extract the next four characters, which represent the product code. Enter your answer in column D and include a heading in cell D1.
A check digit is the final character added to a code to help detect errors by verifying that the rest of the code has been entered or scanned correctly. Extract the last digit, enter your answer in column E, and include a heading in cell E1.