need HELP removing box with question mark PLEASE

  • Thread starter Thread starter Ward
  • Start date Start date
W

Ward

Hi. I exported a list of contacts from microsoft outlook as a .csv
file. In the notes section of the outlook file I have items that are
separated with a carriage return which then has notes on the next line
and next line and so on.

Well when viewing the data in excel, those carriage returns show up as
a box with a question mark.

Well I was going to use the "text to columns" command, but that won't
work with that pesky box with a question mark inside.

So unless someone has another idea, I need to replace that thing with
a comma, so then I can separate those lines into individual columns.

Thanks so much.

Ward
 
You can use my CellView add-in to examine exactly what character(s) are
represented by the box and question mark. Once you have determined the
character(s), you can use Find/Replace to change it to the appropriate
character.

See http://www.cpearson.com/Excel/CellView.aspx


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Thanks for the reply Chip.

I've downloaded and installed the viewer in excel 2007. It tells me
that I have a few squares (013 and 010). That is the offending
characters. I'm still not sure has to how I am to use the find/
replace command to eliminate it however. I tell excel to find 013 and
it gives me nothing.

I'm on the right track, but just no quite there yet.

Thanks for some more help.

Ward
 
Back
Top