Posted to microsoft.public.excel.misc

Jeff[_4_]

external usenet poster

Posts: 23

concatenate problems

Hi
I'm using Excel 2002 and am trying to combine 3 cells containing text
into another cell using the formula:
=CONCATENATE("M2","K2","N2")
But instead of a combination of the 3 columns of text into the new cell,
all I get as a result is
M2K2N2 instead of the contents of these cells.

What am I doing wrong?

Thanks.

Jeff

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
concatenate every second row to first row	Kelly E.	Excel Discussion (Misc queries)	2	January 10th 06 04:25 PM
concatenate and then take off last #	NTaylor	Excel Discussion (Misc queries)	6	December 21st 05 06:04 PM
I know how to concatenate ,can one de-concatenate to split date?	QUICK BOOKS PROBLEM-	New Users to Excel	1	July 26th 05 05:07 PM
Un - Concatenate?	JudithJubilee	Excel Worksheet Functions	2	July 11th 05 09:57 AM
concatenate	Christy Quesenbery via OfficeKB.com	Excel Worksheet Functions	1	April 7th 05 08:09 PM

All times are GMT +1. The time now is 09:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us