| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining values out of different columns
Hi,
I've seen an answer on this one before, but I cannot find it back! I have 2 colums i need to combine colA ColB ColC= result 100 10 10010 20 10020 200 10 20010 30 20030 40 20040 300 20 30020 .... goes on for 1000 rows Who can help me on this one? Thanks in Advance Hans |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining values out of different columns
Hi
Pls try this formuala: =IF(A1<"",A1&B1,A1&B1) regards Rajesh "stumbler" wrote: Hi, I've seen an answer on this one before, but I cannot find it back! I have 2 colums i need to combine colA ColB ColC= result 100 10 10010 20 10020 200 10 20010 30 20030 40 20040 300 20 30020 .... goes on for 1000 rows Who can help me on this one? Thanks in Advance Hans |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining values out of different columns
Sorry earlier posted formula had a small mistake
corrected one Use below formual for 1st cell =IF(A1<"",A1&B1,A1&B1) Use below formual for rest of cells =IF(A2<"",A2&B2,A1&B2) "rajesh" wrote: Hi Pls try this formuala: =IF(A1<"",A1&B1,A1&B1) regards Rajesh "stumbler" wrote: Hi, I've seen an answer on this one before, but I cannot find it back! I have 2 colums i need to combine colA ColB ColC= result 100 10 10010 20 10020 200 10 20010 30 20030 40 20040 300 20 30020 .... goes on for 1000 rows Who can help me on this one? Thanks in Advance Hans |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining values out of different columns
For the 1st cell you may wish to change
=IF(A1<"",A1&B1,A1&B1) to =A1&B1 ? :-) -- David Biddulph "rajesh" wrote in message ... Sorry earlier posted formula had a small mistake corrected one Use below formual for 1st cell =IF(A1<"",A1&B1,A1&B1) Use below formual for rest of cells =IF(A2<"",A2&B2,A1&B2) "rajesh" wrote: Hi Pls try this formuala: =IF(A1<"",A1&B1,A1&B1) regards Rajesh "stumbler" wrote: Hi, I've seen an answer on this one before, but I cannot find it back! I have 2 colums i need to combine colA ColB ColC= result 100 10 10010 20 10020 200 10 20010 30 20030 40 20040 300 20 30020 .... goes on for 1000 rows Who can help me on this one? Thanks in Advance Hans |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining values out of different columns
On Aug 22, 1:24*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: For the 1st cell you may wish to change *=IF(A1<"",A1&B1,A1&B1) to =A1&B1 ? *:-) -- David Biddulph "rajesh" wrote in message ... Sorry earlier posted formula had a small mistake corrected one Use below formual for 1st cell =IF(A1<"",A1&B1,A1&B1) Use below formual for rest of cells =IF(A2<"",A2&B2,A1&B2) "rajesh" wrote: Hi Pls try this formuala: =IF(A1<"",A1&B1,A1&B1) regards Rajesh "stumbler" wrote: Hi, I've seen an answer on this one before, but I cannot find it back! I have 2 colums i need to combine colA *ColB * * ColC= result 100 * 10 * * * * 10010 * * * * *20 * * * * 10020 200 * 10 * * * * *20010 * * * * *30 * * * * 20030 * * * * 40 * * * * *20040 300 * 20 * * * * *30020 .... goes on for 1000 rows Who can help me on this one? Thanks in Advance Hans I found the original solution back http://groups.google.com/group/micro...4c82be1a88199b Thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| Combining data from two columns into one - appending new values tothe end of one column | Excel Worksheet Functions | |||
| Combining columns????? | Excel Worksheet Functions | |||
| Combining columns | Excel Discussion (Misc queries) | |||
| Combining Columns | Excel Discussion (Misc queries) | |||
Linear Mode
