Mac Forum / Applications / Excel / June 2006

We are having an issue where we are opening documents generated in
Excel X in Excel 2004 and the column width especially but also row
sizes change to a smaller size. This results in ### symbols in various
cells. We are looking to upgrade to Office 2004 and have hundreds of

I have a worksheet in Excel that contains address and tel numbers etc. the
address are contained in one column and each part of the address (road name,
city, county, post code etc) are separated by commas.
Is there a way to get these items into individual cells, a reverse

I am a novice user to Microsoft Excel for Mac (2004) and i am having
trouble following the instructions for protecting a worksheet's
formulas and headings from accidental --or deliberate -- changes.  Is
there a way to turn a worksheet into a "form" so a user can enter

I created a spreadsheet that spits out a nice clean report page for a
client.  The page is to be printed, or converted to PDF for sharing.  I'm on
a OSX mac, so I can do this easily.  However, my client is in the Windows
world and claims to have no clue as to how to create a PDF.  I ...

I am using XL 2004 (v.11.2.3) and Visual basic for Applications (VBA)
11.2 for Macintosh, and want to do something which should be real
simple - except that I can't find a way!  I would really appreciate
help on how to set about this or what I might be doing wrong.

I need to have cells with 4  formatting conditions. Excel allows up to 3.
Does someone have a way to accomplish this, maybe with a macro?
I know formulas can be used in conditional formatting, as in
=max (A1:a32)=A1

I worked on some Excel spreadsheets in the morning and do not recall
having any problems. If I recall correctly, I closed the files as normal
and probably quit Excel straight after.
At around this time I wanted to back up my HD to an external but for

If a single cell contains more than around 1000 characters, they don't all
print (or show on preview). Is there an upper character limit?

Following a problem with my G4 I reinitialised it and loaded OS 10.3.9 and
Office 2004 and everything else from scratch
An important 10 sheet 892KB XL file, which I have built up over many years,
has many macros and has crossed from Mac to Pc and back again with no

I have contact information in one cell. The lines of the contact
information are seperated by multiple spaces. I need to split each line
into a seperate cell. Can you suggest a way to do this?
The data looks like this:

Hi, and thanks in advance for any help or direction you can provide.
I've had trouble running macros that were created on a PC, on a new
Mac.  First I thought it had to do with various code-related issues, or
ActiveX controls, but after running isolated tests of different

hI  everybody:
how can I locked only a few cells with formulas without protecting the whole
sheet so can others edit the ws without messing with the formulas????
I'll appreciate all the help.