scrappinghappy
Pearl Clutcher
“I’m late, I’m late for a very important date. No time to say “Hello.” Goodbye. I’m late...."
Posts: 4,306 
|
Post by scrappinghappy on Jun 28, 2014 17:52:17 GMT
Can one take a sheet of address labels in word and convert to spreadsheet with Name/Street/Town/State/Zip as column headers?
Thanks
|
|
CeeScraps
Pearl Clutcher
~~occupied entertaining my brain~~
Posts: 3,823
|
Post by CeeScraps on Jun 28, 2014 17:56:30 GMT
I've never tried that.
|
|
scrappinghappy
Pearl Clutcher
“I’m late, I’m late for a very important date. No time to say “Hello.” Goodbye. I’m late...."
Posts: 4,306
|
Post by scrappinghappy on Jun 28, 2014 18:14:26 GMT
Thanks Gypsy girl. Would of worked if it had been a table in Word but it was sheets of address labels  I converted to text, copied to excel, removed blank lines, made sure all addresses were three lines then used this Assuming the data starts in A1, in B1 and copy right and down, =INDEX($A:$A, COLUMN() - 1 + 3 * (ROW() - 1) ) |
|
