I have formulas which will extract first, middle and last names but I
need one that will append the JR/SR/III onto the middle name.  What I
have now assumes it is the last name.
Thanks for your help.

I need a macro to insert a blank row after each row in my document;
that is, every other row will be an inserted row.
For example:
I have:

I would like to make numbers within certain ranges show up in different
colors.  I'm very new to Excel, but have programmed scripts in Access and
know what an Access macro is - as well as the Access "conditional
formatting" feature.  What is the best approach to take in Excel?  ...

We have an employee that swears that her mouse cursor in excel is almost
always the standard windows pointer and only occasionally when she's doing
special functions does it change over to the large plus symbol. Now mine
(and every other computer in the office) is just the ...

Is there a way to have multiple toolbar buttons that fill different
colors? For example, one toolbar button for fill blue, another to fill
red, another to fill yellow.
Currently, to work with several colors, I need to click to get to the

How can I format a column of figures to show that if the result is
zero or negative amount it will just show a zero or be left blank.
I am attempting to show the difference between figures that have been
invoiced to figures that have been added and thus need to be invoiced.

I have a price sheet that displays prices like this 6.26248371689101 need to
change them to display $6.26 have tried currency, accounting, everything.
Please help
Thanks for any help!

Wie kan mij vertellen hoe de werkbalk "snelle toegang"met al zijn icons is
te saven.
Dit ivm een nieuwe installatie van excel. Het voorkomt dat ik al die icons
wederom moet opzoeken.

I have 5 columns with rows that go to inifinity. I would like to sort the
first column which is a LAST NAME A column alphabetically. If I do this, I
also need to have rows B C D and E follow that sort. Is this possible?
Thanks!

Whenever I export a chart to web in Excel 2003, the fonts always look bolded
and distorted.  I've tried disabling PNG export (GIF export only), changing
the DPI, even changing the font itself (i.e. from Arial to Verdana), and
loading the exported page from another computer; ...

Hi All,  I have some data in an unfriendly format.  It's organized like this:
xxxyyyzzzaaabbbcccdddeeefff
ggghhhiiijjjkkklllmmmnnn
ooopppqqqrrr

All of a sudden I have started having some problems when trypoing to open a
spreadsheet located on the desktop.
The last time the file(s) were open, there was a hesitation when closing
them, and on the next attempt I receive the message that "Excel cannon open

I need sites similar to http://www.b2bcompass.com
Thank you
bispl

I'm having a problem at excel that i don't have on other computers:
when i click save as, i would like, as usual, that on the file name
window, apeared only the current file name, and not "copy from
"filename"".

I have a 5000+ list of phone #s in an excel sheet.  I need to add a 1 to each
of them.  The numbers look like this:  9545555555.  I wabt to add the 1
prefix without a dash or space.  Could someone be so kind as to help this
newbie???