CONCATENATE function


I have the following formula I a cell

=CONCATENATE(B13," ",C13)

it works well, it cats the first name a space and the surname

but when I try to copy the full name from the cell the formula is copied
I just want to copy the text complete to another cell.

Can this be done?

Thanks for any advice/help.






--
Nospam

Hello Nospam,

This is easy to do manually. Once you hace copied the cell, you need to
use "Paste Special" to paste only the cell's value.

Edit Paste Special...

Once the Paste Special dialog appears click the option "Values" in the
Paste section and then OK.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=563986

Thanks

thought it would be obvious.

Thanks again





In message ,
Leith Ross
writes

Hello Nospam,

This is easy to do manually. Once you hace copied the cell, you need to
use "Paste Special" to paste only the cell's value.

Edit Paste Special...

Once the Paste Special dialog appears click the option "Values" in the
Paste section and then OK.

Sincerely,
Leith Ross



--
Nospam