View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nospam nospam is offline
external usenet poster
 
Posts: 16
Default concatenate function

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