concatenate function

RE: 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

Thanks

thought it would be obvious.

Thanks again





In message <[email protected]>,
Leith Ross <[email protected]>
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