Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 23
Default problem in editing imported file

As I have done many hundreds of times before, but not on this computer,
I was trying to edit some data this afternoon. Its in a very messy
format, so I just imported the text, line by line.

Then I planned to parse the line. Imagine my surprise when I indicated a
fixed width of two for state, and found out that Texas is "T". I finally
did a workaround, and parsed off three places to get two, but find this
very peculiar.

Also - when I got done, some of the columns wouldn't size down; they
seem to have spaces at the end, but when I edit/erase the spaces, the
text starts to disappear. I promise I am not drinking.

Can anyone shed some light on this problem - any assistance would be
gratefully appreciated.
--
Regards,

P D Sterling
New York, Texas & Texas, New York
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can I display the file name of the imported text file in another c John-G Excel Discussion (Misc queries) 0 May 13th 05 03:38 PM
Problem Editing Macro in Shared Excel File [email protected] Excel Discussion (Misc queries) 1 March 19th 05 06:43 PM
Problem Editing Macro in Shared Excel File [email protected] Excel Discussion (Misc queries) 0 March 19th 05 06:01 PM
problem working with time data imported from text file afaqm Excel Worksheet Functions 1 February 24th 05 08:02 AM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 04:45 PM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"