Dear friends,
You have a list of employees in an Excel sheet with names and surnames in different columns. However, you need the full name (including surname) in a single column only. Do you know how to do this?
Alternatively, if you have the full name in a single column but you want to have the surname in a different column, how can this be achieved?
Please see the attached file for a simple method.
You have a list of employees in an Excel sheet with names and surnames in different columns. However, you need the full name (including surname) in a single column only. Do you know how to do this?
Alternatively, if you have the full name in a single column but you want to have the surname in a different column, how can this be achieved?
Please see the attached file for a simple method.
1 Attachment(s) [Login To View]