Posted to microsoft.public.excel.programming

nospam

external usenet poster

Posts: 16

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using the concatenate function	BIAKathy	Excel Discussion (Misc queries)	3	January 8th 09 11:46 PM
concatenate function help	andresg1975	Excel Discussion (Misc queries)	2	October 19th 06 04:32 PM
Concatenate Function	BenG	Excel Discussion (Misc queries)	3	September 21st 06 10:08 PM
How to use function Concatenate	Peter Wallin	Excel Programming	1	February 27th 04 03:37 PM
Concatenate Function	Dnk	Excel Programming	1	February 11th 04 02:10 PM

All times are GMT +1. The time now is 11:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us