| View previous topic :: View next topic |
| Author |
Message |
wmldityer
Newbie
Joined: 28 Sep 2011
Posts: 1
|
 Posted: Wed Sep 28, 2011 7:58 am Post subject: combining various cells with both char. & num. into one |
 |
|
newbie
Is there a way to combine various cells (a4) which contains G, (b4 which contains 03, (c4) which contains X into one cell (Example d1.....G03X)? Did it with a program called ASAWIN. Changed numbers to text in format but still does not work with =SUM
Thank you. |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8984
Location: Lexinton, Kentucky, USA
|
| Posted: Wed Sep 28, 2011 9:13 am Post subject: |
|
|
=A4&B4&C4
or
=CONCATENATE(A4;B4;C4) |
|
| Back to top |
|
|
|
