combine 3 columns into one in excel 2011 for mac

Question

i am trying to manipulate a bunch of string elements i have put in a column on excel. i then filled the preceding column with data, and then the following column as well. now i want to delete the column boundaries, leaving one column with the data from all the columns in that one. like so:

      A    B    C  
    1 @    #    @   
    2 @    #    @  
    3 @    #    @  

and i want it to look like this:

  A     B     C  
1      @#@  
2      @#@  
3      @#@  

the actual names of the columns and rows are irrelevant, i think, but they are adjacent.

Answer 1

Set up column D to use the formula =CONCATENATE(A1,B1,C1) then delete columns ABC