View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Floyd[_2_] Phil Floyd[_2_] is offline
external usenet poster
 
Posts: 8
Default Replacing characters

I have exported data from a database that looks like this in excel. .

BLN B172-ZNste
tc122  

I can't figure out how to take out the squares because I don't know what
they are. The file was exported to a .csv and this is what I get. Text to
column doesn't work nor does Find/Replace. What are these characters and
how can I eliminate or replace them.

Phil