Saving files in Excel 2003

  • Thread starter Thread starter Issues with saving excel files
  • Start date Start date
I

Issues with saving excel files

When I saved my file, it saved all the info into one column and not the way I
designed it. Each entry in that box had a little box after it. See example:

123(little box)456(little box(

It didn't save each column like I set it up to. Any ideas why or how I can
recover the info in the right format?

"CHICAGO TITLE INSURANCE CO Home lending 1111 MAIN STREET SUITE
200 Vancouver WA 3602232000

try to amagine a little box after each entry and that's my issue. "
 
Try the below formula with a sample data in cell A1
=SUBSTITUTE(A1,CHAR(10)," ")

If that does remove the box; then the box is the carriage return. You can
select the column and right click>FormatCells>Alignment>check Word wrap

If this post helps click Yes
 
Back
Top