Article: It will need to be written in Excel in the lowercase to use this method. The flash fill function can read and change names so that the first letter of the first and last name is capitalized. Enter them in a single column. Leave a blank column to the right of the list of names. If you don’t currently have a blank column to the right of your list of names, right click on the lettered column above your list of names. Select “Insert” and a new empty column will appear to the right. For example, if your first lowercase name were in cell A1, you would go to cell B1. For example, if the first cell says “joe biggins,” type “Joe Biggins” in the cell to the right. Press “Enter.” ” It will learn the pattern and make a similar change in the data series. You can also use the short cut code, “Control” and the letter “E” to activate Flash Fill. To avoid duplication, click on the top of the original lowercase column. Right click and press “delete” to get rid of it and leave the list with proper cases. Make sure Flash Fill has worked on your whole list before deleting.
What is a summary of what this article is about?
Use this section if your series is a list of proper names. Complete your list of names using lowercase letters. Click on the cell to the right of the first name that is listed. Type the same name as the cell in A1, but include proper capitalization of first and last names. Go to the “Data” menu and select “Flash Fill. Delete the column with the lowercase names.