Forum Discussion

rayeverest's avatar
rayeverest
Copper Contributor
Jan 10, 2019

Combine two Excel columns without losing data

I need a way to combine two Excel columns without losing data. I would like a method which is fast and easy.
excel
Office
JWR1138's avatar
JWR1138
Iron Contributor
Jan 10, 2019

What do you mean by combine? Text or numbers? What are you looking for the result to be?

rayeverest's avatar
rayeverest
Copper Contributor
Jan 12, 2019

Any option I find involves loss of data.

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 12, 2019

    If you have data in A1 to A10    and B1 to B10   then in C1 type = A1&B1 then copy this formula down.

    • rayeverest's avatar
      rayeverest
      Copper Contributor
      Jan 12, 2019

      How do I copy the file down?

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Jan 14, 2019
        Copy the formula (Ctrl + c) then select the cells where the formula needs to go and Paste (Ctrl + v)

Resources