List:General Discussion« Previous MessageNext Message »
From:David Blomstrom Date:June 7 2004 7:33am
Subject:OT: Errors from Extra Spaces in Spreadsheets
View as plain text  
I've been having a tough time importing
comma-delimited files into my database tables. I just
discovered that most of the errors are similar to this
one:

"060 " is not a valid integer value

I checked my spreadsheet - Microsoft Works - and
discovered that there's a space after many of my
numerals. I'm not sure how to remove these spaces. I
didn't see anything in the Help files. I could do a
search and replace, but that would also wipe out
spaces between words  - like...

Tripp<space>County

I just wondered if there's a simple trick anyone knows
of for getting rid of spaces like these or preventing
them in the first place. Thanks.



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 
Thread
OT: Errors from Extra Spaces in SpreadsheetsDavid Blomstrom7 Jun
  • Re: Errors from Extra Spaces in SpreadsheetsMartin Gainty7 Jun
  • Re: OT: Errors from Extra Spaces in SpreadsheetsRobert A. Rosenberg7 Jun