Combining Info in 2 Cell to make one

  • Can anyone tell me how to take the information in A1 and B1 and combine it to read text in C1 ...I tried to Merge the two but only get what in the one cell

    Thanks in advance

  • Simplistic way: put a space in C1, then in D1 type in "=A1&C1&B1".

    When finished use Edit/copy and Edit/paste special for D1. Then you can delete any of the other cells.
    Good luck. Terry

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!