i'm using the concatenate function and i'm wondering if there is anyway go get it to auto update. if i change the value of a cell it wont update the cell with the concatenate function in it unless i click in the box and hit enter (it doesn't even work if i highlight the cell and hit enter, i have to physically click in the function bar). Any suggestions?