Microsoft Excel is an excellent tool that, in addition to managing numerical data, facilitates the use of text type values. In this regard, this application offers several useful functions, so you can learn how to correct misspelled names in your Excel table in this guide where we explain the easiest procedure to achieve this goal.
What is the Excel function that allows you to correct a misspelled name?
There is no Excel function that allows you to correct a misspelled name. Instead, Microsoft Excel offers a spell check tool with which you will be able to correct all the text that you include in a spreadsheet according to certain parameters, such as the language or the handling of uppercase and lowercase letters when necessary.
PROPER
The PROPER function allows you to convert the first letter of a word or a text string to uppercase. In effect, the function converts all other letters to lowercase. It is important to note that the function can perform the conversion to several words of the same text and requires the format = PROPER NUMBER (the cell where the text is located)
CORRECT
The Excel application allows you to correct the texts by checking their spelling. Once you access the ‘Check’ ‘Spelling’ option, the tool selects the entire spreadsheet including charts, comments, headers and footers. Suggestions are then displayed based on language and other autocorrect options.
Excel’s autocorrect window presents several options such as correcting two capital letters in a row, capitalizing the first letter, and capitalizing the days of the week. Also, you can enable or disable autoformat when you type text in a cell and even replace some text with mathematical symbols.
How can you run an Excel function on your spreadsheet?
There are two ways to run an Excel function on your spreadsheet either by using the formula bar if you are knowledgeable about various functions or by using the insert function wizard. You can carry out this procedure quickly and easily if you have a Windows PC or with the mobile application.
If you have your Windows PC
If you have a Windows PC, access Microsoft Excel and in a spreadsheet, you will have to go to a specific cell where you will execute the function. There, write the = sign followed by the name of the function and in parentheses add the parameters. Parameters typically refer to other cells or constant numeric values.
You can also use the wizard to insert functions. For this, click on ‘fx’, an option that you will find just above the spreadsheet. Later, Select a category and press the ‘OK’ button. Click the red arrow to the far right of each parameter and locate the cell that requires the formula. Finally, press ‘OK’.
With the mobile app
You can also run an Excel function on your spreadsheet with the mobile app. First, download Google Sheets from the Google Play Store to install the tool on your mobile device. Then, go to Google Sheets and press the cell where you want to add a formula.
Then press ‘fx’ function and select the category and function you need. Then the wizard will show you a function description so that you can type the names of the cells that the formula requires. Add the mathematical symbols that are necessary and click on ‘Done’. Immediately, the function will be executed in Excel.
What should you do to sort the names with surnames in your Excel table?
It is possible to sort names with surnames alphabetically in an Excel table. If you have inserted full names in a column that belongs to a table and you want sort list by last nameselect the entire column, click ‘Find & Select’ and choose the ‘Replace’ option.
Immediately, the ‘Find and Replace’ window will open. Place your cursor in the ‘Find:’ option text box and press the space bar there. Then type the @ symbol in the ‘Replace with:’ box and click the ‘Replace All’ button to remove the blanks. Then press the ‘OK’ button.
Select a new column where the names and surnames will be displayed in order. Click on ‘Data’ and press ‘Sort A to Z’ where you will see a dialog box. There, you need to check the ‘Expand selection’ box and press the ‘Sort’ button. Also, you can separate the first and last names in the table if you prefer.
