Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've tried the offset command and a loop macro (which it's been several
years, so have been unsucessful) for the following scenario: In column A, I have several contacts pasted in address label format. I'd like to get them in column format. Column A currently looks like: John Doe 123 Anywhere Lane Mountains, CA 95555 (555) 555-5555 Jane Doe 1111 Anywhere Lane Oceans, CA 97777 (555) 555-7777 There are two blank rows between the two contacts, which is what is hanging me up. Thanks so much! A |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |