I'm trying to add a formula that adds the first and last names to a cell. It works fine but I'm having trouble adding a space between the names. Any ideas on the correct syntax?
Dim LastRow As Long
LastRow = Range("AJ" & Rows.Count).End(xlUp).Row...