| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy row with an empty cell for each row in a sheet | Excel Discussion (Misc queries) | |||
| How to copy data to the next empty cell in a column | Excel Worksheet Functions | |||
| Copy from row above if cell is empty in column | Excel Discussion (Misc queries) | |||
| Copy a string text to cell if another cell not empty | Excel Discussion (Misc queries) | |||
| Copy Data From Filled to Empty Cells | Excel Discussion (Misc queries) | |||
Linear Mode
