Prev: Filter
Next: comparing more then one column with numbers and letters
From: Donna on 20 Apr 2010 19:46
Yes, that worked great. Thank you soooo much.
"Max" wrote:

> 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
>
First  |  Prev  | 
Pages: 1 2
Prev: Filter
Next: comparing more then one column with numbers and letters