Can't text to column as separated by unknow character

[Saab95]

Hi there,

I have the following data in one cell in excel that I want to "text to column".
However, even if it looks like spaces between the numbers it is not. If I paste it to word it shows °°°
But even with putting ° in the other box of the text to column wizard it doesn't work.

Any idea ? Thanks.

(PS: Data comes from an html file)

 

[JvdV]

Are these tab characters? Non-breaking spaces? Can you paste the actual input here?

 

[Fluff]

What does this formula return

=CODE(MID(A1,4,1))

 

[Alex Blakenburg]

It might be worth swapping that for, especially if the above returns 63.

=UNICODE(MID(A1,4,1))

 

[Saab95]

Thanks, I need each figure in a separate column and can't use MID or LAST, etc as figures are changing everyday. And this will be a daily task.

 

[Fluff]

Can you answer the questions in posts#3 & 4

 

[Saab95]

What does this formula return

=CODE(MID(A1,4,1))

It returns 160

 

[Saab95]

It might be worth swapping that for, especially if the above returns 63.

=UNICODE(MID(A1,4,1))

It also return 160

 

[Fluff]

Ok, how about

=TEXTSPLIT(A1,CHAR(160),,1)

 

[Saab95]

Ok, how about

=TEXTSPLIT(A1,CHAR(160),,1)

Better, now returns each "part" in a different column. Never seens this function before.
Now I think I must convert them to numbers, right ?