If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 values to one column
Hello from Steved
I have 2 colums column A has numeric and column B has a single letter. As an example cell A1 will have 1 and B1 T and in A2 119 B2 T, A3 73 and B3 T. Is there a formula so that in C1 will be 1T and C2 will be 73T and C3 119T. Thankyou. |
#2
|
|||
|
|||
2 values to one column
|
#3
|
|||
|
|||
2 values to one column
-----Original Message----- Hi Steved! Start trying to work things out; it's easy to just ask but you'll get more in terms of learning by struggling to get the answer. Just adding using + won't work! But how else might I join the contents of cells? Use the concatenator &. -- Regards Norman Harker MVP (Excel) Sydney, Australia . Nothing wrong with asking questions but Steved should be a MVP by now!!! |
#4
|
|||
|
|||
2 values to one column
|
#5
|
|||
|
|||
2 values to one column
Thankyou Norman.
=A1&B1 -----Original Message----- Hi Steved! Start trying to work things out; it's easy to just ask but you'll get more in terms of learning by struggling to get the answer. Just adding using + won't work! But how else might I join the contents of cells? Use the concatenator &. -- Regards Norman Harker MVP (Excel) Sydney, Australia . |
#6
|
|||
|
|||
2 values to one column
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Comparing values in two columns to generate result in a third column | DDM | Worksheet Functions | 1 | April 16th, 2004 05:20 PM |
adding values from another worksheet by matching criteria | Frank Kabel | Worksheet Functions | 2 | March 16th, 2004 03:15 PM |