While analysing an Excel sheet the other day, I needed to combine two columns so that I could get names in the format
firstname lastname (the list had been provided as
lastname,firstname). As it happens, doing so is relatively easy. You do it on a cell by cell basis, by using basic excel commands.
- If you simply want to combine two columns:
- Combine two columns with a space between them:
You then copy the command and paste it into the rest of the cells you want to apply it to, and you should see it change the numbers for each row.