I'm not certain I understand what you want to do, but I think you are question is because the columns have text. You can add the cells A1 + A2 + A3 or you can use the Concatenate(A1,A2,A3).