Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Jul 24, 11:34 am, smurray444
wrote: Thanks for your replies again. I have tried changing the maximum row value to a range of numbers (as low as 20!), but the same result occurs. With regard to the latest point, the text file is fomatted as follows: -67.45832 82.87501 0.2068079 -67.37498 82.87501 0.2068079 -67.29166 82.87501 0.2068079 -67.20832 82.87501 0.2068079 -67.12498 82.87501 0.2068079 -67.04166 82.87501 0.2068079 -66.95832 82.87501 0.2068079 -66.87498 82.87501 0.2068079 -66.79166 82.87501 0.2068079 ...etc etc... However, when displayed in Notepad, the rectangle (carriage return?) symbol separates each row (i.e. it is displayed as one long string and not in columns as shown above... although the above is the result of a direct copy and paste!). So maybe this is causing a problem? If so, is there a way of getting round this? It would take ages to go though the text file reformatting it and removing the symbols for example. Any ideas would be very much appreciated. Many thanks Steve Under the heading of proofread before hitting send that should read: That is normally a problem of a file that came from a UNIX system. There are utilities on the net to convert UNIX to DOS files. This simply adds the CR after the LF. Peter Richardson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime 28 - Out of stack space | Excel Programming | |||
Number of space in a string | Excel Discussion (Misc queries) | |||
Can I find a string with or without a space after the last charact | Excel Programming | |||
how to remove a space after a string? | Excel Programming | |||
NEED HELP-----Removing a space at the end of a string of character | Excel Discussion (Misc queries) |