Excel is frequently used as a lightweight database application for tracking contact lists and similar information. When data, such as names, is imported from other applications, it may not be in the format desired. For example, a name might be put in a list as Adam Smith, rather than Smith, Adam. Converting names from one format to another can be done easily through the use of the LEN command in Excel.
- Skill level:
- Moderately Easy
Other People Are Reading
Open your list of names in Excel. The list of names should be in column A.
Enter the following formula in column B1:
Note that there is a space between the quotation marks in the find function.
Enter the following formula in column C1:
Enter the following formula in column D1:
Copy the contents of cells B1, C1 and D1 down for as many rows as you have names. For example, if your name list goes to row 200, make sure you copy the contents of cells B1, C1 and D1 down through B200, C200 and D200.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for