formula to copy data to empty cell   

Using Excel 2003. Creating a client list, I want to copy home address to 
mailing address if mailing address is blank. For example, C2 is home address, 
L2 is mailing address. Thanks in advance.

date: Sat, 27 Sep 2008 00:05:00 -0700   author:   Olchannel

Re: formula to copy data to empty cell   

Just use a helper col, say col M
Put in M2: =IF(L2="",C2,L2)
Copy M2 down as far as required. Then copy col M, overwrite col L with a 
paste special as values. Clean up by clearing col M
-- 
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
--- 
"Olchannel" wrote:
> Using Excel 2003. Creating a client list, I want to copy home address to 
> mailing address if mailing address is blank. For example, C2 is home address, 
> L2 is mailing address. Thanks in advance.

date: Sat, 27 Sep 2008 03:06:06 -0700   author:   Max