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

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

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

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

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