How do I quickly format my birthday column?
Using Excel:
- Highlight the entire “birthday” column
- Right-click and select “Format Cells”
- Select “Date” as the Category: and “2012-03-14” as the Type
- Note: If, by chance, you convert dates to yyyy-mm-dd format, save and close the file as .CSV, and then reopen your .csv file in Excel, you will need to reformat your dates again. Why? Because Excel converts dates to mm/dd/yy by default when opening a .csv.
Using Google Sheets:
Highlight the birthday column
Choose Format / Number / More Formats / More date and time formats
Select “1930-08-05” from the drop-down list and then click "Apply"
How do I split one column (lastName,firstName) into two columns?
Using Excel:
Insert a new blank column to the right of the name column you wish to split
Highlight the name column (Column B in this example)
With the name column highlighted, click Data, Text to Columns
Select “Delimited” and click “Next” button
Select “Comma” and click “Next” button
Choose “General” and the column in which you want the name entered
Confirm that name has been split into two columns:
Remember to change your column headers appropriately:
Save the file as file format .CSV
Using Google Sheets:
Insert a column to the right of name column (if you don’t you’ll lose all info in next column)
Highlight the name column
Choose Data / Split text to columns
