|
|
Counting characters by
Howard
Is there any way to count characters (spaces included) in a cell to insure
that the characters in a specific cell do not exceed a preset number?
Thanks...
|
March 26th, 2010 12:27 PM
by Howard
|
3 |
164 |
|
|
|
March 26th, 2010 10:49 AM
by Edi
|
4 |
145 |
|
|
|
March 26th, 2010 10:41 AM
by Vahid
|
2 |
183 |
|
|
borders don't appear in print preview? by
Claire
Hi,
I'm using Excel 2003 and I have a spreadsheet which I have set up so that
'gridlines', 'black and white' and 'draft' are unchecked. The cells where...
|
March 26th, 2010 09:42 AM
by Claire
|
3 |
279 |
|
|
|
|
2 |
174 |
|
|
How many entries can Excel handle!? by
Rebecca Sage
I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be...
|
|
7 |
218 |
|
|
speak cells in Excel by
Dave
Someone has changed the settings on my computer so that every time I enter
anything in a cell, the computer speaks what I typed in upon hitting the
enter...
|
March 26th, 2010 04:35 AM
by FSt1
|
3 |
237 |
|
|
Need Formula to renumber column by
crj
I have a sheet that contains 20 tasks that have a column that ranks their
priority 1 thru 20. I need to be able to take task 15 and change the priority
to 3....
|
March 26th, 2010 03:17 AM
by crj
|
4 |
177 |
|
|
if(isna(match formula by
Anthony[_8_]
The following formula will not work and for the life of me I can not
figure out why:
=if(isna(match($a2,$e$2:$m$7,0)),$a2," ")
In cell a1 is the text "All...
|
|
8 |
135 |
|
|
|
March 26th, 2010 02:48 AM
by zos
|
0 |
150 |
|
|
VB code by
tsraj
I am using Office 2007. In Excel, I like to write a code in Visual Basic to
copy the contents of the cell above into a blank cell down below and repeat
the...
|
March 26th, 2010 02:35 AM
by JLatham
|
5 |
106 |
|
|
summing data in multiple columns by
brad1824
I'm looking for a formula to lookup criteria in column A and add the results
in columns B, C, D, E, etc.
For example I would like to know the sum of how many...
|
|
4 |
119 |
|
|
Error in formula after auto-filtered by
may25
In a table, i have one column (let say Column A) where the formula is
referred to another workbook. The formula works well, until i do an
auto-filtered on...
|
March 26th, 2010 01:39 AM
by may25
|
2 |
107 |
|
|
Sum of every nth cell in a column by
SnackFoodGirl
I am trying to figure out the formula for adding the nth cell in a given
column. I am using the formula below to add every 4th cell but it is just one
that I...
|
|
3 |
205 |
|
|
Mail merge by
Nenagh
Hi ,
I am doing a mail merge, on e for the fields is a weight which displays as
..425. When i do the merge this field displays as .4251111333300000 or...
|
|
4 |
149 |
|
|
Track Changes Colour by
bubbles
In Excel 2003, how can I change the colour that track changes displays in?
At the moment changes are showing up in Navy which is not easily identifiable...
|
March 26th, 2010 01:00 AM
by bubbles
|
0 |
117 |
|
|
|
March 25th, 2010 11:29 PM
by FSt1
|
1 |
150 |
|
|
Always On Top by
Murray
Can someone please advise how I can have Excel on top of any other programs I
have open at all times?
|
March 25th, 2010 11:16 PM
by Murray
|
0 |
110 |
|
|
|
March 25th, 2010 10:55 PM
by Reeza
|
2 |
181 |
|
|
rearrange the data in columns by dates? by
Frank
How do I rearrange data by dates in reverse order?
Example: I'd like to change the order to 3/21/2010, 3/22/2010,
3/23/2010...etc.
Current order
Column
A ...
|
|
1 |
206 |