Spreadsheet: 35670d1233258505-updated-w-new-problem-extract-address-information-into-columns-sample
Sheet: Sheet1

1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
2 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
2 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
GIBBERISH | GARBAGE | GIBBERISH | GARBAGE | LIST |  | RE | PORT D | ATE 01/27/2009 | PAGE     3
BR | T NR T | SHORT NAME
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
2 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
2 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
GIBBERISH | GARBAGE | GIBBERISH | GARBAGE | LIST |  | RE | PORT D | ATE 01/27/2009 | PAGE     3
BR | T NR T | SHORT NAME
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
2 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
2 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222
1 | 25422 | HERBE JODY
 |  | [NAME]
 |  | BOX 253 |  | ISHPEMING | MI | 49855 | 255
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
3 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 554377 | JOKEL HARV
 |  | HARVY JOKELICH | LANE A DIXON
 |  | 21980 WOODLAND RD. |  | GRAND RAPIDS | MI | 45886 | 9005
1 | 54233 | WALLA ANDR
 |  | [NAME]
 |  | 21927 WOOD RD |  | LIMPIC | MI | 49855 | 9006
1 | 225112 | THOMA FRAN
 |  | FRANK THOMAS | [NAME]
 |  | 700 E SHARON AVE |  | DETROIT | MI | 49999 | 1222