Data_Preparation_I_HOMEWORK (1)

0 manhattan il 154 9 6 oakland city in 4 76 6 0

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ATTAN, IL 154 9 6 OAKLAND CITY, IN 4 76 6 0 SLAUGHTERS, KY 2056 9 LAUGHLIN, NV 89 029 NASHUA, NH 306 3 COLUMBUS, OH 4 3236 OWENSBORO, KY 37004 COLUMBUS, IN 4 7202 WARSAW, IL 29 029 REYNOLDSBURG, OH 24 9 58 COLUMBUS, OH 4 3229 FORT WAYNE, IN 4 6 86 3 KEYSTONE, IN 4 6 759 LIBERTY, IN 4 7353 MANILLA, IN 4 6 150 ATLANTA, IN 4 6 031 ANDERSON, IN 4 6 011 CORTLAND, IN 4 7228 WAVERLY, KY 2276 0 MONTEZ UMA, IN 4 786 2 SCHAUMBURG, IL 26 816 ADRIAN, IL 4 0352 DAYTON, OH 4 54 23 KNIGHTSTOWN, IN 4 6 14 8 COLLINSVILLE, OH 4 5004 NEW SALEM, IL 21727 GOLDSMITH, IN 4 6 04 5 SPRINGFIELD, MA 39 04 0 CIRCLEVILLE, OH 4 3113 COLUMBUS, OH 4 3230 KEYSTONE, IN 4 6 759 SUNMAN, IN 4 704 1 EVANSVILLE, IN 4 7732 NEWPORT, KY 26 39 9 LEBANON, IN 4 6 052 LIBERTYVILLE, IL 6 009 2 MESA, AZ 85204 CASA BLANCA, NM 87007 SPRINGFIELD, VA 39 86 4 City State Z ip Use Flash Fill T ime S pent (minutes)? Use Excel 2013's new Flash Fill method to separate the data. This one's pretty easy, but remember it's only available in Excel 2013. G OLD BEACH, OR 9 74 4 4 CORY, IN 4 784 6 BLOOMINGTON, IL 374 24 FORT WAYNE, IN 4 6 89 6 INDIANAPOLIS, IN 4 6 24 1 FORT WAYNE, IN 4 6 804 SCHAUMBURG, IL 33756 GILBERT, AZ 85233 DENVER, CO 36 374 BRIMFIELD, IN 4 6 720 BLOOMINGTON, IN 4 74 01 SAINT LOUIS, MO 6 316 7 NEWPORT, KY 2786 0 WILLIAMS, OR 9 754 4 YERINGTON, NV 89 4 4 7 SEELYVILLE, IN 4 74 04 FORT WAYNE, IN 4 6 806 LAS VEGAS, NV 89 134 ROCKFORD, OH 4 5882 DAYTON, OH 4 54 20 OWENSBORO, KY 37734 PATRIOT, IN 4 74 07 CARLISLE, IN 4 7838 KANSAS, IL 12224 NEW BOSTON, MI 4 816 4 BROADLANDS, IL 4 2539 DENVER, CO 29 4 35 DELAWARE, OH 4 2124 NATIONAL CITY, CA 18525 WOLFLAKE, IN 4 6 79 6 WAVERLY, KY 2276 0 STANLEY, KY 27507 CHICAGO, IL 209 77 LONGMONT, CO 38204 SEBREE, KY 20203 SPRINGFIELD, IL 206 33 CHICAGO, IL 319 34 KANSAS CITY, KS 6 6 111 MANITOU, KY 1326 4 ALPHA, OH 4 5301 CHICAGO, IL 30839 TOHATCHI, NM 87325 UNIONTOWN, KY 2239 5 MARKLE, IN 4 6 770 LIBERTY CENTER, IN 4 6 76 6 CEDAR LAKE, IN 4 6 303 ALBUQUERQUE, NM 87118 LANSING, IL 14 035 CINCINNATI, OH 4 5270 LITTLETON, CO 224 9 4 GLENEDEN BEACH, OR 9 7388 SHIRLEY, IL 26 4 6 7 FORT WAYNE, IN 4 6 86 5 FORT WAYNE, IN 4 6 808 GREENWOOD, IN 4 6 14 3 CINCINNATI, OH 4 5228 WEST COLLEGE C OR NER, IN 4740 8 SHAWNEETOWN, IL 3086 2 ALBUQUERQUE, NM 8719 9 FOUNTAINTOWN, IN 4 6 130 CHULA VISTA, CA 4 0075 KNIGHTSVILLE, IN 4 7857 STURGIS, KY 216 6 4 LONG BEACH, CA 3714 2 MULE CREEK, NM 88051 BLOOMINGTON, IN 4 74 01 DUGGER, IN 4 74 06 LAS VEGAS, NV 89 118 HOOVEN, OH 4 5033 LIGONIE...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online