formula to copy data to empty cell

  • Thread starter Thread starter Olchannel
  • Start date Start date
O

Olchannel

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.
 
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
 
Back
Top