In cell D5 use the TRIM, LEFT, and FIND text functions to extract the guests first name from cell A5. AutoFill the function down to D22.

1/25/2020 1 Today's Date Spa Service Requests 2 First Name Service Requested City & State Bernalilo, NM Hair Color Treatmen Farmington, NM Benson, AZ Benson, AZ Bisbee, AZ Hair Color Treatmen Bernalilo, NM Santa Fe, NM City Date Of Birth 4 Guest Name Age State 2/20/1978 5 olivia Stone 41 Hair Treatment 6 Mia Ramos 11/11/1972 47 Makeup Service Women's Facial Golf Massage 7 Isabella Hudson 10/19/1975 1/2/1969 2/26/1970 4/14/1977 10/6/1969 5/26/1978 6/19/1986 44 8 Rhonda Griffith 51 9 Steven Lucas 49 10 Elizabeth Anderson 11 Jessica Montgomery 12 Ella West 13 Joseph Wallace 14 Joshua Pierce 15 Ryan Jennings 42 Women's Facial 50 Makeup Service Golf Massage Farmington, NM Farmington, NM Bernalilo, NM Bisbee, AZ Benson, AZ Hair Color Treatment Bisbee, AZ Bernalilo, NM 41 33 5/12/1969 6/5/1971 11/8/1967 5/8/1974 6/9/1976 8/22/1974 3/9/1985 5/12/1986 Pedicure 50 Full Massage 48 16 Judy Brown 52 Manicure 17 Hannah Rowe 45 18 Jill Mcdonald Full Massage 43 Santa Fe, NM Santa Fe, NM 19 Glenn Barker Pedicure 45 20 Mia Rivera Pedicure 34 21 Jane Montgomery 22 Susan Burgess Farmington, NM Santa Fe, NM Makeup Service 33 6/14/1964 Pedicure 55 23