that character can be found by
=CODE(MID(A1,6,1)) in your example, where A1 contains quot;1029 · etcquot; -
目前分類:title (4957)
- May 27 Tue 2008 20:44
How to determine the value of a printable character?
- May 27 Tue 2008 20:44
change 800 to 8.00
Is there an easy way to move the decimal point other than adding a column and
dividing by 100 then deleting wrong numbers?
- May 27 Tue 2008 20:44
Complicated Question
- May 27 Tue 2008 20:44
Getting count
Sheet1
Column A
- May 27 Tue 2008 20:44
How do I make a spreadsheet that skips each cell and adds color
What I actually mean, I like to have green every other cell, for about 125
cells, is there a way to , not with VBA, I can't get that into my senior
- May 27 Tue 2008 20:44
Multiple condition help needed
column c = employee number
column i = bolts
- May 27 Tue 2008 20:44
convert $1.00 to text one dollar.
Hi. have a spread sheet, and need to type in dollar amount, and in another
cell, have that dollar amount written in text. Example cell 1 [$1.02] cell
- May 27 Tue 2008 20:44
Validation Issues
I have an excel workbook that is used to select available services on one tab,
and transfer the services with a quantity greater than 0 (and therefore will
- May 27 Tue 2008 20:44
error: Not enough system resources to display completely
Has anyone seen this error shown on a very large workbook? I'm guessing I
need to cut down on the size of the file. Any suggestions on how to do this
- May 27 Tue 2008 20:44
how do I insert column headings or labels without using a row?
- May 27 Tue 2008 20:44
Clearing associated dropdown fields
Hello,
- May 27 Tue 2008 20:44
customize keyboard shortcuts
How do I Customize keyboard shortcuts under Excel?
- May 27 Tue 2008 20:44
why a reference to an empty cell is not considered empty
I do not understand why a cell that contains a formula which result is empty
is not considered as an empty cell.
- May 27 Tue 2008 20:44
Mixed Cell
- May 27 Tue 2008 20:44
Pivot Table counts instead of data
I have a worksheet that has one column with weights. Whenever I run
the pivot table, the table has a quot;countquot; of the number of weights,
- May 27 Tue 2008 20:44
Any function to ...
Hi,
- May 27 Tue 2008 20:44
macro problem
- May 27 Tue 2008 20:44
conditional formating on rows amp; cols depending on one cell
HI,
Is it possible to apply a conditional formating to a complete row or column
- May 27 Tue 2008 20:44
help please
Hi i have a worksheet that i use for racing data, after each race i reset
all the money values to 0, but the total one i would like to copy to a new
- May 27 Tue 2008 20:44
why can't i edit my charts in excel
I am trying to edit a chart that i saved in excel, but i am unable to edit
it. I can't even highlight it, so it can't be deleted