Reply to thread

Does your excel have auto correction on ? I would try t writ a program ( I would in C but I guess whatever works ) to read the file and output ASII codes of characters, the space may be from upper half of ASCII table.

Edit : Do you have to use excel ? I think it would be much easier in notepad.

BTW it is ASCII #160, I have imported part of it into database ( the easiest for me ) and code

declare @i int

select @i=0

while @i < 10

 begin

  select @i = @i + 1

  select (substring( c, @i, 1 )), ascii(substring( c, @i, 1 )) from aaa

 end

gave me

                

-    ----------- 

1             49 

                 

-    ----------- 

　            160 

                 

-    ----------- 

P             80 

                 

-    ----------- 

l            108 

                 

-    ----------- 

a             97 

                 

-    ----------- 

y            121 

                 

-    ----------- 

e            101 

                 

-    ----------- 

r            114 

                 

-    ----------- 

,             44 

                 

-    ----------- 

2             50