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.
From India, Malappuram
Acknowledge(0)
Amend(0)
1446You 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.
From India, Malappuram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Employee Data - Format.xls
10 ways to format Excel data.pdf