Looks like a space but not able to split cell

[dpags]

I have a spreadsheet with a list of first and last names in a single column. The field LOOKS like there is a space between first and last name but when I try to do a "Data, Text-to-Columns" command, it does not recognize the space. Any ideas? I manually inserted a space in the first couple of rows to see if that would work and it did... why would Excel not recognize what 'appears to be a space'? Thanks for any help that can be provided!!

 

[VoG]

It could be character 160 if the data was taken from a web page. In Text to Columns instead of space tick Other then in the box hold down ALT and type 0160 using the numeric keypad.

 

[dpags]

It could be character 160 if the data was taken from a web page. In Text to Columns instead of space tick Other then in the box hold down ALT and type 0160 using the numeric keypad.

That totally worked! You are awesome and thanks!

 

[dpags]

One more question - this did not work when I tried it on an address field where the alpha is preceded by numeric characters.... is there another code?

 

[VoG]

Try copying just the "space" and pasting it into a spare cell (say A1). Then

=CODE(A1)

will give you the ASCII code.

 

[dpags]

Thanks - I did a Google search on 0160 and found that the "other" code I needed was 032. Thanks so much for your help!

 

[VoG]

Oh, 032 is a space