I have a some basic columns in Excel like this:
Full Name | First Name | Last Name | Billy | Bob | Sue | Anne | Super | Man | Joe |
I want to merge the first name and last name together into the Full Name column, separated by a space.
Is there a macro or something that could do that?
Also in the case of Joe who doesn't have a Last name listed, could it just put
Joe without a space at the end?