formula to copy data to empty cell

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.
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Word Documents 4
Copy addition formula of non-consecutive horizontal cells 2
Grouping Names in Mail Merge 0
Split data in cells 1
Find & Sort 1
Recover Outlook Express data 1
Hiding recipient addresses when sending to lot of recipients usingOutlook 2010 4
Pasting a cell into bookmarked table from excel vba 1

Top