combining columns and using concatenate
On the face of it, think you could try this
Put in say, D2: =IF(A2="","",IF(B2<"",B2,A2))
Copy D2 down to return required results. Then copy col D and overwrite col A
with a paste special as values. Clear col D. You're done in about 10-15 secs.
Inspiring? hit the YES below
--
Max
Singapore
---
I have 2 columns A and B. Many of the cells are blank in column B. When
column B has information in it, I want it to replace the information in Col A
with the information from Col B-if col B is blank, then keep the
information from Col A
|