Scanning into Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Scanning into Excel

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Long Island, NY
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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"

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

  4. #4
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ††
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

DMCA.com