Forum Discussion
Formula(s) to combine columns in to 3rd column
I've seen several examples of something close to what I'm wanting to do, but I've not seen this specific example discussed yet. I have 2 columns with data and blanks and I want to combine the dat...
In D2:
=IF(B2="", C2, B2)
Set the number format of D2 to the custom format 000000000
Fill down.