|
|
|
December 1st, 2006 07:25 PM
by Curious
|
2 |
147 |
|
|
Character count within a cell by
Mhunter
How many characters are allowed within one cell? I found a way to count words
but is there a way to count characters?
|
|
2 |
139 |
|
|
Shortcuts to go to cell by
ART
Anybody know of easy ways to jump to a certain cell. It could be a macro, Put
in a letter or anything. I need it to manuver quickely around the sheet. Any...
|
|
1 |
166 |
|
|
Worksheet forumal help by
James@
I have a person in accounting that has a 15+ page, 5mb workbook that has so
many forumals i am not sure where to start. The users is saying that there
is a...
|
|
1 |
146 |
|
|
Creating a list by
Gary''s Student
There is a trick in Excel. Hold down the ALT key and then touch enter!
This will enable you to enter multiple lines in a single Excel cell.
--
Gary's...
|
|
0 |
172 |
|
|
Character count within a cell by
Mhunter
Thank you!
"Gary''s Student" wrote:
Thousands of characters
=LEN(A1) will display the number of characters in A1
--
Gary's Student
|
November 30th, 2006 06:01 PM
by Mhunter
|
0 |
167 |
|
|
Character count within a cell by
Gary''s Student
Thousands of characters
=LEN(A1) will display the number of characters in A1
--
Gary's Student
"Mhunter" wrote:
How many characters are allowed within...
|
|
0 |
127 |
|
|
Shortcuts to go to cell by
Prasadkakarla
hi
prasad from crystalgallery i think my answer is useful for u
which cell u want to go particularly you should add that cell watch window
where ever u work...
|
|
0 |
174 |
|
|
Shortcuts to go to cell by
Gary''s Student
Edit Goto and then enter the cell address
or just CNTRL-g
--
Gary's Student
"art" wrote:
|
|
0 |
170 |
|
|
|
November 29th, 2006 12:00 AM
by hccatmo
|
0 |
230 |
|
|
Sorting data by
ART
Is there a way to automaticaly sort data. For E.G. I have a list of venders
with their names in column B, Telephone No. in column C, Addresse in column D
and...
|
|
3 |
144 |
|
|
Select Sum by
Lowkey
How do I set criteria to sum only on filtered amounts?
|
|
2 |
155 |
|
|
|
|
1 |
147 |
|
|
Export custom Macro Button Images by
RWN
Home - xl2kPro, Work-xl'03
I routinely create macro's for various functions (Personal.xls) and export them to/from
work - no problems there
I also create...
|
|
1 |
153 |
|
|
|
|
2 |
159 |
|
|
Automatically Run macro by
Anift
Hi All,
I have a cell in my Sheet which shows the last updated date ( E11), Now i
have macro coded which sents email from Macro if the difference last...
|
|
2 |
152 |
|
|
|
|
1 |
180 |
|
|
Excel 2007 Error Reopening Pivot tables by
Mike L
Has anyone got the error:
"Excel has found unreadable content"
and then
"Removed records: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part...
|
November 24th, 2006 10:53 PM
by Mike L
|
6 |
209 |
|
|
Excel 2007 Error with OLAP KPIs by
Mike L
It appears that connecting to an SSAS 2005 cube or perspective that has any
KPIs in it will cause Excel 2007 to save the spreadsheet in a corrupted
format...
|
November 24th, 2006 05:20 PM
by Mike L
|
0 |
204 |
|
|
Where are the engineering functions? by
Charles Belov
Excel 2003 help tells me I can use HEX2DEC to convert hexadecimal
numbers to decimal, but when I try to use it in a formula
=HEX2DEC(A2)
Excel changes it to...
|
|
2 |
149 |