How can i enter Brandi Marks and Joe Blow in a cell so that when i resize it
the names never have the first name on one line and the last on another? I
mean Brandi Marks would be treated as if there was no space but the blank
acted as another character.

I would like to present a dropdown list for a cell consisting of the four
suit symbols (hearts, clubs, diamonds, spades) and the letters "NT".  Can't
get data validation to do this as its font can't be changed.
Does anybody know how to do this any other way (perhaps with with VBA)?

Is there any way to feed information from excel into word?
I have created an entire searchable database of our 1600 accounts i
excel by product.  Now what I am wanting to do with it is export th
accounts returned into a word document set to "Avery 5160" label type

Hi,
I need help with evaluate Method.
What I am trying to do is write for loop for following.
       UserForm2.Label1.Caption = ""

Does anyone know why the Excel Viewer doesn't support VBA?

yesterday I put up a query because im trying to find a way of selectin
the last entry in a column then copying it intoa seperate cell. Thank
for the replys - someone got back to me saying to use
WorkSheets("Sheet1").Range("J65536").End(xlUp).Copy

When I have a formula entered in a cell I want the back ground to chang
to a color. How do I do that with conditional formatting or is there
different way? I don't want it to change because of any particula
varibles I just want it to simply change color if a formula i

I have a workbook that helps keep tabs on properties that I buy and sell.
Each sheet is exactly the same as the other with the exception of the top
sheet which is to serve as a totals sheet and is named "Totals".  I have
named the last sheet "Final."  I would like cell C16 of the ...

My knowledge of using excel formulas is limited to basic cals, but I need to develop it quick!
I have a spreadsheet that is growing daily (currently about 350 records) and I need to count the number of entries by the first two digits of the postcode (zip code).  I guess countif is ...

i am not sure if this is going to make anysense but i will give it a g
anyway,
my current axis of my chart is displayed like this

I am looking for limitations in Excel (in general) as well as specifics (pivot
reporting).  I found this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rc
r_creating_dc_v1_13du.asp
It's helpful in the general sense but it doesn't give me info on other

just wanted to know how can i pick up the totals from the two sheets fo
a particular item and put them under the Actual and Forecast rows fo
the particular time-frame..
i have already written a macro for getting the common items from th

I have a subtotal on another sheet and would like several columns i
another sheet to ref cell AV6 and drag that formula down but when
copy/paste the formula over to the next column it puts AW6 in and
want to always start with AV6 in every column so I can drag the formul

Here's what I want to do but I'm too dumb to it. Usually I Google
before asking here but my Internet is down though NGs and email work.
PART 1
In cell A1 we enter a date, say, 07/22/04. If the date in A1 is a

I have a list with three rows each.  Does anyone know how
I can sort these entries with all three rows included?  I
have tried to associate them, but cannot find a way.  Any
help would be greatly appreciated.