Merging Cells

**steal_m** · 03-26-2008, 01:02 AM

Hi team, I have two columns that I want to merge, they both never contain records in the same row. The Concatenate function works fine except for that it merges values equal to zero . eg.. Column A Column B
123 0
0 45

After Concatenating these two columns. My result would be 1230 and 045, but i really want 123 and 45. The remaining records in the columns are similiar, you wont find two records in a row. Always zero and a number.

**Portuga** · 03-26-2008, 01:10 AM

Try:

=if(A1=0;B1;if(B1=0;A1;A1&B1))

**mudraker** · 03-26-2008, 01:43 AM

steal_m

Please read the forum rules

When you signed up to this site you agreed not to post the same question to multiple forums

Your duplicate thread have been deleted from the Excel Programming

A thread with the rules is available at the top of each forum or see links below