Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Formula not working
I have been using the concatenate function for a while now but recently it
just stopped working. these are numerical columns. i go to insert- Function- concatenate, put in the cell #'s i want in the correct box and press enter. all works according to plan. however once i try to have the data extend down the column, it just shows me the data from the first box on every box below it! What usually works is just doing copy of the original cell and highlighting down. all the rest of the data just appears. it's not working and i have a deadline. help me please! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Formula not working
Hi Helen,
alternatively you can use following:- =(Ref1)&""&(Ref2)&""&(Ref3) ... and so on..!! where Ref are the references in the excel worksheet which you want to concatenate. -- Dilip Kumar Pandey MBA, BCA, B.Com(Hons.) New Delhi, India "helen" wrote: I have been using the concatenate function for a while now but recently it just stopped working. these are numerical columns. i go to insert- Function- concatenate, put in the cell #'s i want in the correct box and press enter. all works according to plan. however once i try to have the data extend down the column, it just shows me the data from the first box on every box below it! What usually works is just doing copy of the original cell and highlighting down. all the rest of the data just appears. it's not working and i have a deadline. help me please! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Formula not working
If you use
=CONCATENATE(A1,B1) in C1 then it will change to =CONCATENATE(A2,B2) if you copy it down to C2... Pl. make sure that you do not have absolute references in the formula (addresses with $ in it like $A$1... "helen" wrote: I have been using the concatenate function for a while now but recently it just stopped working. these are numerical columns. i go to insert- Function- concatenate, put in the cell #'s i want in the correct box and press enter. all works according to plan. however once i try to have the data extend down the column, it just shows me the data from the first box on every box below it! What usually works is just doing copy of the original cell and highlighting down. all the rest of the data just appears. it's not working and i have a deadline. help me please! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Formula not working
Make sure you're in automatic calculation mode.
In xl2003 menus: tools|calculation tab helen wrote: I have been using the concatenate function for a while now but recently it just stopped working. these are numerical columns. i go to insert- Function- concatenate, put in the cell #'s i want in the correct box and press enter. all works according to plan. however once i try to have the data extend down the column, it just shows me the data from the first box on every box below it! What usually works is just doing copy of the original cell and highlighting down. all the rest of the data just appears. it's not working and i have a deadline. help me please! -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Formula not working
I tried both the way you and Dil suggested, "=CONCATENATE(A1,B1)" adn
"=(Ref1)&""&(Ref2)&""&(Ref3) ..." respectively. neither worked. my columns are completely numeric. i dont think my stuff is in absolute reference (there are no $ signs in the formula bar). any other ideas? thanks "Sheeloo" wrote: If you use =CONCATENATE(A1,B1) in C1 then it will change to =CONCATENATE(A2,B2) if you copy it down to C2... Pl. make sure that you do not have absolute references in the formula (addresses with $ in it like $A$1... "helen" wrote: I have been using the concatenate function for a while now but recently it just stopped working. these are numerical columns. i go to insert- Function- concatenate, put in the cell #'s i want in the correct box and press enter. all works according to plan. however once i try to have the data extend down the column, it just shows me the data from the first box on every box below it! What usually works is just doing copy of the original cell and highlighting down. all the rest of the data just appears. it's not working and i have a deadline. help me please! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Formula not working
Turn on automatic calculation under ToolsOptionsCalculation
Or Office ButtonExcel OptionsAdvancedFormulas Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 07:37:08 -0700, helen wrote: I have been using the concatenate function for a while now but recently it just stopped working. these are numerical columns. i go to insert- Function- concatenate, put in the cell #'s i want in the correct box and press enter. all works according to plan. however once i try to have the data extend down the column, it just shows me the data from the first box on every box below it! What usually works is just doing copy of the original cell and highlighting down. all the rest of the data just appears. it's not working and i have a deadline. help me please! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Formula not working
hi everyone,
yeah, my automatic calculation thing was on but for some reason, i tried to try the formula again and it suddenly worked. no idea why or how but still very happy about it. thanks for all the advice, hendy "Gord Dibben" wrote: Turn on automatic calculation under ToolsOptionsCalculation Or Office ButtonExcel OptionsAdvancedFormulas Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 07:37:08 -0700, helen wrote: I have been using the concatenate function for a while now but recently it just stopped working. these are numerical columns. i go to insert- Function- concatenate, put in the cell #'s i want in the correct box and press enter. all works according to plan. however once i try to have the data extend down the column, it just shows me the data from the first box on every box below it! What usually works is just doing copy of the original cell and highlighting down. all the rest of the data just appears. it's not working and i have a deadline. help me please! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate with Line Feed not working | Excel Discussion (Misc queries) | |||
Concatenate function not working for me | Excel Discussion (Misc queries) | |||
Concatenate formula or & | Excel Discussion (Misc queries) | |||
Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions |