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 |
concatenate function
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 |
concatenate function
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 |
All times are GMT +1. The time now is 10:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com