cell Marging

[Former Member]

Hi,

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.

[amitrathi239 · Accepted solution]

Hi,

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)

or

=[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.

Thanks,

Amit

[Former Member · Accepted solution]

thanks for you help. It solved the problem. I have another problem it would be great if you can help me about hierarchies. I will post it in 20 minutes. It would really save my job if I get the answer. Thanks.