Formatting Cell Text

[Brian C]

I have a spreadsheet that contains about 61 pages of
information. Each row is 1 cell that we've made larger to
accomidate an address being centered in the cell using
spaces and word wrap.

In Excel 2000 it was fine.

We've upgraded to Excel 2003 and now the formatting is
lost. The cell shows the text all over the place kind of
like it is taking the spaces as text entry and without
manually going into each cell and backspacing we can't get
it to line up.

Is there some option that we don't have ticked or did the
upgrade change the formatting of the cell someway?

In 2000 it looks like (Centered in the cell):

ABC Company
123 Main St.
Anytown, US 12345
123-456-7890

In 2003 it looks like this:

ABC Company 123 Ma
in St. Anytown, US 1
2345 123-456-7890

Again, it's 61 printed pages of this and there are about 3
addresses PER ROW so manually backspacing will be a HUGE
time consumption.

Hopefully there is some easy answer for this?

Thanks in advance!

Brian

 

[Bob Umlas]

Looks like you need to adjust the column width because you obviously have
word-wrap on.
Bob Umlas
Excel MVP

 

[Guest]

Bob,

First, thanks for the quick reply!

I opened it back up in 2000 (I only have one computer left
with Excel 2000) and copied down the column widths and
they are IDENTICAL to those in 2003.

No change in look.

Any other ideas?

I verified the cell formatting to be the same (Center,
Center and Word Wrap) in both versions and the column
width is the same in both versions, but the 2003 seems to
be "reading" the spaces and throwing off the centering.

Thanks again,

Brian

 

[bj]

If it is seeing spaces, You might want to use the trim()
function to remove the spaces efore and after your input
data

-----Original Message-----
Bob,

First, thanks for the quick reply!

I opened it back up in 2000 (I only have one computer left
with Excel 2000) and copied down the column widths and
they are IDENTICAL to those in 2003.

No change in look.

Any other ideas?

I verified the cell formatting to be the same (Center,
Center and Word Wrap) in both versions and the column
width is the same in both versions, but the 2003 seems to
be "reading" the spaces and throwing off the centering.

Thanks again,

Brian

 

[dderolph]

I gather you still have the file created in Excel 2000, with the
formatting you had with Excel 2000. Is that right?

Did you open it in Excel 2003 and save it under a different name?

 

[Brian C]

I opened the file in 2003 and saved it with a different
name and it didn't change the result.

I also e-mailed it to someone with Excel 2002 and it
opened fine as well.

Seems there is some issue with 2003...

Thanks for the response!

Brian

 

[Brian C]

The problem has been fixed!

The culprit was that SP-1 wasn't installed for Office 2K3

After SP-1 installed, everything "popped" back into place!

Thanks for all your suggestions!

Brian

 

[Gord Dibben]

Brian

Thanks for getting back with this information.

Goes into the archives.

Gord Dibben Excel MVP