LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Concatenate function not working for me

I'm using InsertFunctionConcatenate and using the wizard

text 1 I'm clicking on the first cell I want to concatenate L2

text 2 I'm typing in ", " (without the quotes)

text 3, I'm clicking on the 2nd cell I want to concatenate M2

then enter

I'm getting =CONCATENATE(L2,", ",M2) in N2 as opposed to "text in
first cell, text in second cell"

What am I doing wrong?

....Lisa XL03

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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/& Function ? Ash Excel Discussion (Misc queries) 5 February 23rd 07 04:57 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
Can I concatenate text in cells to make a working formula? Matt S. R. Excel Discussion (Misc queries) 11 November 11th 05 03:44 PM
Concatenate function in vba camerons New Users to Excel 3 June 15th 05 12:09 AM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"