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
    Marlon

    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!

Register Yourself Login