Question Re: cell Marging in Technology Q&A

cell Marging

Former Member — Wed, 18 May 2011 16:05:09 GMT

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.

Re: cell Marging

amitrathi239 — Wed, 18 May 2011 21:45:41 GMT

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)

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

Re: cell Marging

Former Member — Thu, 19 May 2011 11:57:50 GMT

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.