I have "First Name" in 1 column, There is a list of First Name AND "Last Name" is in 2nd column and the list is Also there.
I have to retrieve the first name and last name together in one cell without the header of the cell (ex. first name and last name) but I need to appear the actual first name and last name together. Please Help and Thanks in Advance.
Amit Kumar replied
Try like this.
1) Drag First Name in the column.Then drag last Name in the same column formula bar.
Syntax should be like this.
=[First Name] + " "+[Last Name] (" " These can be use for the spacing between first name and last name)
=[First Name] +[Last Name]
or use the Concatenation Function which is in the Functions.
If you do not want the header row then right click on the header then remove and go to remove row.
or delete the header column definition and remove the border.
Hope this helps you.