I need to resort names in a cell from John amp; Jane Doe to Doe, John amp; Jane.
目前分類:title (5957)
- Dec 25 Tue 2007 20:41
Resorting full names
- Dec 25 Tue 2007 20:41
from Excel to TXT file
Hi,
I am trying to create a document in EXCEL, while I am updating the table,
- Dec 25 Tue 2007 20:41
assigning a macro to a button
I have a macro that runs fine and I added a button to my spreadsheet from
the forms control menu, but I can't figure out how to assign the macro to the
- Dec 25 Tue 2007 20:41
Confused about relative references in named formulas
I'm new to this, so perhaps I'm missing something obvious.
- Dec 25 Tue 2007 20:41
Page Setup
How can I set up Excel so that when ever I open a new workbook with Ctr N,
all the worksheets in the workbook are set to zoom level of 75% instead of
- Dec 25 Tue 2007 20:41
copy page settings to multiple worksheets in excel?
I have excel 2002. I have multiple worksheets in a workbook. I changed and
reset the page setup in one sheet to have a certain size (57%), margins and
- Dec 25 Tue 2007 20:41
Vlookup amp; Trim
I have this dilemma. I have a number in column B of spreadsheet one. I need
to split that number and put the first 8 digits into column D of another
- Dec 25 Tue 2007 20:41
find and replace
How do I search for a certain number in cells and either highlight the row or
replace the cell with another number?
- Dec 25 Tue 2007 20:41
How to make a null cell as 0 (Zero) so that the subtraction works
Each cell in my worksheet is a function call that is requesting data from
webservice. But at times some of these cells dont have any values; and this
- Dec 25 Tue 2007 20:41
Non-excel related problem about thumbnails
- Dec 25 Tue 2007 20:41
sum up total baed on names
Let ay I have this table:
- Dec 25 Tue 2007 20:41
HELP..Stretching on print out
i installed a new 19 LCD monitor and it seems evere since then my worksheet
in not properly proportioned. Monitor setting is at 1280 x 1024 32 bit. With
- Dec 25 Tue 2007 20:41
formula for sum 30 or more
I want to show in a cell the sum of another cell if 30 or more, if less than
30 zero.
- Dec 25 Tue 2007 20:41
Insert Next? Or insert a variable number of records...how?
I am preparing to design a new spreadsheet, but I don't know how to achieve
one aspect of it.
- Dec 25 Tue 2007 20:41
Find the first Value in a Row and Retrieve the Header for That Column
- Dec 25 Tue 2007 20:41
once I set up my margins to 90% it still prints at 65% why?
I have a worksheet with 3 columns on and I've set up my margins and adjusted
my work to print out at 90% also going through page preview which still shows
- Dec 25 Tue 2007 20:41
problem with LINEST
[to:
microsoft.public.excel.misc, microsoft.public.excel.programming
- Dec 25 Tue 2007 20:41
vlookup with linked cell references
vlookup is returning incorrect information some of the time. The initial cell
it is looking up is a linked word. Is this what is causing the problem? If
- Dec 25 Tue 2007 20:41
Count data based on past dates
- Dec 25 Tue 2007 20:41
Formulae for Tolerence
Is there a function that can be used to identify tolerences of answers.