#1
|
|||
|
|||
Help need for concatenate function issue
Hi All
I just wanted to let you know about the concatenate function which is not updated automatically if i change the values in the cell which already called in the function. for example, I have the row which needs to be merged using the concatenate function. I have created the function but, if i changing the value in the cell the changes has not updated in the function cell so that i have double click the function cell and put ENTER then it has updated. Also if try to drag the function below to apply all the rows but, the same above not updated automatically and i have double click each cell and put ENTER manually. Please anyone advise how to resolve this issue. Thanks Ganesan. G |
#2
|
||||
|
||||
Are your calculations set to Automatic?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Usually in the excel if we use the formula we need to drag and use other cells too. But in the concatenate not like that, so that i am just drag all the values but put ENTER manually in each cell to update the corresponding values. |
#4
|
||||
|
||||
[quote=ganesang;135767]Usually in the excel if we use the formula we need to drag and use other cells too.
You're right Ganesang, the concatenate function/formula should return values based on the cell references, but our Moderator is asking you to check if your calculations is set to automatic. Go to the formulas tab, open calculation options, check the "automatic" option. |
#5
|
|||
|
|||
Thank you very much!!!
got it |
#6
|
||||
|
||||
Is the problem solved? Then read my signature
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concatenate function for displaying numbers in words | officeboy09 | Excel | 13 | 08-09-2021 12:59 PM |
RIGHT Function With Concatenate (?) VBA-Need Help with Macro | rsrasc | Excel Programming | 4 | 08-22-2018 12:17 PM |
Concatenate | b16 | Excel | 1 | 01-09-2017 04:51 PM |
Microsoft Quick Parts IF function issue | Rromberg10 | Mail Merge | 1 | 03-23-2016 04:08 PM |
Excel function issue | Nobody | Excel | 1 | 06-30-2014 12:26 PM |