MrExcel Message Board

Go Back   MrExcel Message Board > Question Forums > Excel Questions
Reload this Page Scanning into Excel
Register FAQ Calendar Search Today's Posts Mark Forums Read SearchMrExcel Online StoreLost Password

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

Reply
 
Thread Tools Display Modes
Old Mar 25th, 2002, 07:57 AM   #1
davepor
New Member
 
Join Date: Mar 2002
Location: Long Island, NY
Posts: 7
Default
Has anybody had success scanning data into an Excel worksheet. I have a mailing list with columns seperated by spaces. The data is of varying lengths, so using text to data after the scan results in lots of editing. Thanks

Here is some raw data as requested. I do appreciate all the input.

PRO-AUTO SVC 99 FRANKLIN AVE FRANKLIN SQUARE NY11010-2524 516/354-9511
GOODYEAR AUTO SVC CTR 1080 HEMPSTEAD TPKE FRANKLIN SQUARE NY11010-2686 516/488-1330
LPSWEENEYASSOC INC 980 WASHINGTON ST FRANKLIN SQUARE NY11010-2933 5161175-9724
ULTRA AUTO 151 NEW HYDE PARK RD FRANKLIN SQUARE NY11010-3039 516/328-0497
SYSTEMATIC AUTO SVC 720 DOGWOOD AVE FRANKLIN SQUARE NY11010-4113 516/483-5220
HOPKINS AUTO BODY INC 814 HEMPSTEAOTPKE FRANKLIN SQUARE NY11010-4320 516/328-1184
KING BEAR AUTO SVC CTR 789 HEMPSTEAD TPKE FRANKLIN SQUARE NY11010-4328 516/354-3258
LUKE’S SERVICE CTR 80 HORACE HARDING BLVD GREAT NECK NY11020-1106 5181482-9657
DON JOE AUTO BODY 247ESHORE RD GREAT NECK NY110232420516/466-2828
LEONARD BROTHERS SVC STATION 5 HICKS LNGREAT NECK NY11024-1907 516/466-9434
HILTON MOTORS INC 744 MIDDLE NECK RD GREAT NECK NY11024-1936616/482-5566
PORT MOTORS LINCOLN-MERCURY P0 BOX 83 MANHASSET NY11030-0083 516/365-5858
ZELKO AUTO SVC 55 BAYVIEW AVE MANHASSET NY11030-1805516/365-0585
BOB’S AUTOMOT!VE REPAIR 44 MAPLEPL MANHASSET NY11030-1927516/627-7804
MBA AUTO REPAIR INC 546 PLANDOME RD MANHASSET NY11030-1946516/365-7977
SINGH GULF SVC CTR 546 PLANDOME RD MANHASSET NY11030-1946516/627-7405



[ This Message was edited by: davepor on 2002-03-25 18:49 ]
davepor is offline   Reply With Quote
Old Mar 25th, 2002, 03:33 PM   #2
Jack in the UK
Board Regular
 
Join Date: Feb 2002
Posts: 3,065
Default
Hi I ahve used omnipge pro version 9 now its 10 theres a section for spreadsheets and all that, not so good i felt... can be on trial software as costs 500USD or 310GBP or 700AUD at todays cost in the UK..

other than that i felt all OCR software was usless for this.. into word fine yuuuuck! but newer OCR will deal with boxes and shades and formatting 90% accurate good as after spell checker...


__________________
Free Excel based Web Toolbar available here.

Jack in the UK
J & R Excel Solutions
"making Excel work for you"
Jack in the UK is offline   Reply With Quote
Old Mar 25th, 2002, 03:36 PM   #3
Tom Schreiner
Board Regular
 
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
Default
If you cannot use a query provided by Office, a macro would have no problem breaking it up into columns.
Post an example of the raw stuff.
Tom
Tom Schreiner is offline   Reply With Quote
Old Mar 25th, 2002, 06:39 PM   #4
Russell Hauf
MrExcel MVP
 
Russell Hauf's Avatar
 
Join Date: Feb 2002
Location: Portland, OR USA
Posts: 1,374
Default
Quote:
On 2002-03-25 06:57, davepor wrote:
Has anybody had success scanning data into an Excel worksheet. I have a mailing list with columns seperated by spaces. The data is of varying lengths, so using text to data after the scan results in lots of editing. Thanks
What about text to columns using space as a delimiter?

If this doesn't work, post some example data (like suggested above).

-rh
Russell Hauf is offline   Reply With Quote
Reply

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -4. The time now is 05:13 PM.

Contact Us - Ask Mr. Excel - Tips and Solutions for Excel - Archive - Privacy Statement - Terms of Service - Top

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
All contents Copyright 1998-2012 by MrExcel Consulting.
diabetic desserts recipes recipes Diabetic Soups Holiday Pizza Recipes Popcorn Recipes Recipes For Microwave Pasta Recipes Casserole Recipes Chili Recipes Curry Recipes Crockpot Recipes Apples Recipes Bread Recipes Vegetarian Recipes Vegetable recipes Desserts Recipes Appetizers Ethnic Recipes Meat Dishes Barbecue Recipes Sauces Recipes Marinade Recipes Low Fat Recipes Frugal Gourmet Kitchen Classics Recipes On The Grill Cook Books Seafood Recipes Cajun Recipes Breads Low Fat Low Fat Breads Bread Machine Recipes Yeast Breads Quick Breads Fat Free Vegetarian Salad Recipes Eggplant Recipes Radish Recipes Tomato Recipes Jalapeno Recipes Potato Recipes Lettuce Recipes Cabbage Recipes Beans Ambrosia Recipes Biscotti Recipes Desserts Low Fat Cookie Recipes Cheesecake Recipes Cake Recipes Pie Recipes Muffin Recipes Custard Recipes Best Appetizers Appetizers Low Fat Salsa Recipes Dip Recipes International Recipes Afghan Recipes Alaska Recipes French Recipes German Recipes Greek Recipes Italian Recipes Spanish Recipes Thai Recipes Korean Recipes Chinese Recipes Mexican Recipes Indian Recipes Beef Recipes Pork Pork & Ham Pork Butts Pork Chop Recipes Pork Ribs Rulled Pork Poultry Recipes Stews Recipes Ground Beef Barbecue Grill Barbecue Smoker All Purpose Sauce BBQ Sauce Barbecue Sauce Carolina BBQ Sauce Pickle Recipes Marinades Smoking Low Fat Appetizers & Dips Low Fat Breakfast Low Fat Cakes Low Fat Cheesecakes Low Fat Cookies Low Fat Desserts Low Fat Fish & Seafood Low Fat Meats Low Fat Pasta Low Fat Pies Low Fat Salads Low Fat Sandwiches Low Fat Sauces & Condiments Low Fat Sides Low Fat Soups Low Fat Vegetarian Baker's Dozen Taste of Home Recipe Book Bon Appetit Cookbook Blacktie Cookbook Buster Cook Book Cookbook USA Cook Book Cook Book Sara's Cookbook Sara's Cookbook Appetizers and Dips Poultry recipes Diabetic recipes Holiday recipes Miscellaneous recipes 110 recipes 1986 Usenet cookbook 2900 recipes Cyberrealm recipes Great sysops of world Specialty recipes Ceideburg recipes Cheese recipes Chili recipes Fruits recipes Garlic recipes Great chefs of NY Londontowne recipes Raisins recipes Recipes for kids US Food Vegetarian recipes Bread recipes Drinks Meat Dishes Brisket recipes Caribou recipes Chicken recipes Filet mignons recipes Pork recipes Swordfish recipes Turkey recipes Pasta recipes Uncategorized recipes Ethnic recipes Canada recipes English recipes Ethiopia recipes Germany recipes Greece recipes Mexican recipes Philippines recipes Welsh recipes Microwave recipes Soups recipes Vegetable recipes Asparagus recipes Barley recipes Brown rice recipes Lentil recipes Mushrooms recipes Salads recipes Wild rice Desserts recipes Cakes recipes Chocolate recipes Cookies recipes Ice cream recipes