Remove any hidden characters like CHAR(160)
--
Gary''s Student - gsnu200731


"ValerieJTO" wrote:

I have first and last names in a column that I copied and pasted from the
internet. I did some of my own data cleaning (remove hyperlinks, remove
titles, etc), and now I just want to separate into two columns. For some
reason, Text to Columns (Delimited with Space) is not working. I checked the
formatting of cells, and they appear to be normal - I tried with both General
and Text formats. Any ideas on how to fix?