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
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
Thanks Terry!!! Saved me lots of time..I still did not get the space you were talking about but...Thanks
Don’t have an account yet? Register yourself now and be a part of our community!