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.

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.