![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Mar 2002
Location: Long Island, NY
Posts: 7
|
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 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
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 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
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 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Portland, OR USA
Posts: 1,374
|
Quote:
If this doesn't work, post some example data (like suggested above). -rh |
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|