Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving files in Excel 2003
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. " |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving files in Excel 2003
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 clickFormatCellsAlignmentcheck Word wrap If this post helps click Yes --------------- Jacob Skaria "Issues with saving excel files" wrote: 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. " |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off XML Prompt when saving Excel files in Office 2007 to 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 files crashes when saving after moving another excel sh | Excel Discussion (Misc queries) | |||
Saving .csv files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 modifies XLS files without saving! | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |