Greetings! I am working in a spreadsheet with variables for first name, last name, and birth date (mm/dd/yyyy). My goal is to create a new 10-digit variable that combines the first letter of the first name, first letter of the last name, and the eight digits of the birth date without the slashes.
I take care of the letters with the formula "=LEFT(A1,1)&LEFT(B1,1)." However, I am unable to change the mm/dd/yyyy format to mmddyyyy and add it to the 2 letters without the date changing to its serial equivalent (e.g., 5/16/1973 becomes 26800). I want to use a formula to create the new variable without manually changing all of the dates.
I would appreciate any assistance. Thank you!
I take care of the letters with the formula "=LEFT(A1,1)&LEFT(B1,1)." However, I am unable to change the mm/dd/yyyy format to mmddyyyy and add it to the 2 letters without the date changing to its serial equivalent (e.g., 5/16/1973 becomes 26800). I want to use a formula to create the new variable without manually changing all of the dates.
I would appreciate any assistance. Thank you!