Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

cell Marging


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.

Former Member


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.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question