|
|
changing case by
sos-DC[_2_]
I have a database of over 1,700 line in which more than half have addresses
in ALL upper case.
I need an easy way to change MAIN STREET to Main Street...
( 1 2)
|
|
10 |
168 |
|
|
if formula? by
Jim
Hello,
In A1 I will have one of the following number: 0, 1, or 2, which represents
the number of clients lost.
In cell B1 I have the text "0 Clients...
|
November 19th, 2009 07:44 PM
by Mike H
|
2 |
115 |
|
|
|
November 19th, 2009 07:32 PM
by KMH
|
0 |
133 |
|
|
Clicking on the Ribbon by
Rich
I have a user, who, when in Excel 2007, needs to click on some buttons twice
to make them work. This is not a "double-click" as we are used to.
For instance,...
|
November 19th, 2009 07:28 PM
by Rich
|
0 |
157 |
|
|
|
|
5 |
142 |
|
|
|
November 19th, 2009 06:59 PM
by mePenny
|
4 |
165 |
|
|
Pivot Table percentages by
Timbo
I am trying to create a pivot table to show marketshare percentages,
essentially I need to show the number of transactions in a pivot table as a
percentage...
|
|
1 |
173 |
|
|
Still in need of help by
mePenny
I posted this prior with no final answer to my question.
I'm looking for a formula that can help sort calendar from fiscal year. I'm
hoping this is enough...
|
November 19th, 2009 06:52 PM
by mePenny
|
3 |
127 |
|
|
|
November 19th, 2009 06:39 PM
by Bob I
|
3 |
120 |
|
|
changing "case" of letters by
sos-DC[_2_]
I have a huge database in excel.
Unfortunately, some of the entries are in ALL CAPS (E. MAIN ST or JOHN SMITH)
It is unfortunate as they need to be E. Main...
|
November 19th, 2009 06:27 PM
by Francis
|
4 |
163 |
|
|
Printing Problem by
oceankayakjim
I have a one page Excel file that when I use Print Preview it cliams that
there are 19 pages.
Is there a way to fix this?
Thanks for your time.
--...
|
November 19th, 2009 06:25 PM
by Shane
|
6 |
102 |
|
|
|
|
2 |
161 |
|
|
|
|
2 |
165 |
|
|
Create read-only Excel file 2007 by
Mary Ann
How do I create a normal read only Excel file in 2007? I’ve recently received
a .xlsx file which is read only and I would like to be able to do this...
|
November 19th, 2009 06:05 PM
by Eduardo
|
1 |
157 |
|
|
Column width by
Emece
In Sheet 1 I have a certain amount of data, I want to select some cells and
copy them to Sheet 2 keeping the same format. When I do this, the fonts and
the...
|
|
1 |
112 |
|
|
Urgent Help by
XX23
Working on a word document with the links attached from Excel - Everytime I
open or save the file, getting this error in Excel 2003 and drives me crazy -
The...
|
|
3 |
124 |
|
|
transfer excel menu by
Jeni
I'm having a different computer and need to transfer my customisations over
to it. I know how to transfer my macros & toolbars but can't work out how to...
|
|
2 |
116 |
|
|
Action after save by
PhilosophersSage
Is it possible to create an event after a save? I have a macro that runs
before a save to hide specific sheets and would like those sheets available
after...
|
|
3 |
150 |
|
|
|
November 19th, 2009 05:31 PM
by Oddjob
|
0 |
111 |
|
|
Count Distinct by
Johnny
I've scanned through related posts with no luck. I have a production
spreadsheet with several columns of data. Here are the relevant columns (3)
for my...
|
November 19th, 2009 05:29 PM
by T. Valko
|
7 |
154 |