| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with addresses in rows
Thanks Mark for your help,Yes I want to delete column A and just have
the rows in that format that you gave me.I have about 3000 entries to make tho. Mark K wrote: Do you want to leave the values in column A, or actually move them? If you want to leave them in column A, just put the folowing in (B1) to (C1) and copy them down every 4 rows: (B1) =if(A1="","",A1) (C1) =if(A2="","",A2) (D1) =if(A3="","",A2) This will leave the cells empty if there's nothing in the A column and display it when there is data. -- Mark K ------------------------------------------------------------------------ Mark K's Profile: http://www.excelforum.com/member.php...o&userid=14117 View this thread: http://www.excelforum.com/showthread...hreadid=574018 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| odd and even addresses | Excel Worksheet Functions | |||
| Addresses | Excel Discussion (Misc queries) | |||
| Help with Addresses | New Users to Excel | |||
| How do I convert a single column of addresses into rows for export | Excel Discussion (Misc queries) | |||
| 2 rows of email addresses! | Excel Programming | |||
Threaded Mode
