Data Mess

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Karen (anonymous_at_discussions.microsoft.com)
Date: 02/07/05 

Date: Sun, 6 Feb 2005 16:42:34 -0800

Using Word/Excel 2003
I have a document that consists of 50 pages. The text in
this document is not in any type of order. I want to be
able to import this text from Word to Excel and when in
Excel, transfer the data to (4) columns. How can this be
done if the data is as follows? The first group of data
has 4-6 characters. Then there's space and there's a last
name (space) first name (space) and middle initial. Then
there's 15-25 spaces and then 2 characters (a state
abbreviation)- In the 4th group of data (for the 4th
column)There's 1-2 spaces and then the data, that consists
of 5-10 characters. How can I import this to Excel and
place it in 4 columns if the data is all over the place?
The data is not in table form.

HELP!

Relevant Pages

  • Re: Data Mess
    ... Then in the Find what control, ... Now, if you select and copy the text and then paste it into Excel, ... The first group of data ... > has 4-6 characters. ...
    (microsoft.public.word.docmanagement)
  • Re: Spell checking
    ... characters in a cell before it hits a limit. ... I cannot produce that error in Excel 2008. ... John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, ... McGhie Information Engineering Pty Ltd ...
    (microsoft.public.mac.office.excel)
  • Re: When exporting to excel, field will not exceed 255 characters.
    ... Since Excel 97, you can have up to 32,767 characters in a cell, ... When You Export an Access Report the Memo Field Is Truncated ... Formatted Memo Field Appears to Truncate Data After 255 ...
    (microsoft.public.access.externaldata)
  • Re: When exporting to excel, field will not exceed 255 characters.
    ... Since Excel 97, you can have up to 32,767 characters in a cell, ... When You Export an Access Report the Memo Field Is Truncated ... Formatted Memo Field Appears to Truncate Data After 255 ...
    (microsoft.public.access.externaldata)
  • Re: Writing Japanese or Chinese strings in a text file
    ... characters on the screen. ... start of the file that flags the data as UTF-8. ... VB uses Unicode internally, for 'String' data in memory. ... So they are right in the excel file. ...
    (microsoft.public.vb.general.discussion)