Excel 2007 formulas

Well i have a worksheet with 30 thousand rows and 3 columns. I need to use this formula =+A1:A27202&":"&B1:B27202&":"&C1:C27202 on each row,but i dont know how,and doing it by hand would be too much time consuming.When i select the D row and paste the formula it says 'Data on the clipboard is not the same size and shape as the selected area'.Well if i would find a solution to that,i would also need to transfer the D column(the formula column) with the information not the formulas to a .txt file.
1 answer Last reply
More about excel 2007 formulas
  1. Alright i know how to make apply it to the whole column,but it gives me the same information for every cell.example
    A1.Steve result: Steve:Bob
    B1.Bob
    A2.Sophie result: Steve:Bob
    B2 Steward
Ask a new question

Read More

Office Formula Excel 2007 Apps