| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate function not working for me
That did it Paul!
Thanks!! ....Lisa On Jun 29, 10:43 am, "PCLIVE" wrote: Check that your cell is not formatted as text. Right-click cell, Format Cells- Number tab. Set to General. HTH, Paul wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATE/& Function ? | Excel Discussion (Misc queries) | |||
| concatenate function help | Excel Discussion (Misc queries) | |||
| Concatenate Function | Excel Discussion (Misc queries) | |||
| Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
| Concatenate function in vba | New Users to Excel | |||
Hybrid Mode
