|
|
How do I show all words in a cell? by
BOOMCCORMICK
I am trying to help my daughter do a crossword puzzel project for school. At
the bottom of the puzzel, we were trying to put the clues. How do we show
all...
|
|
4 |
218 |
|
|
Don't want link by
eintpc5146
I have a list of e-mail addresses on a spreadsheet. They automatically
convert to hyperlinks. I don't want these as links- simply a list of
addresses. How do...
|
|
4 |
227 |
|
|
|
|
0 |
312 |
|
|
If condition with text by
ART
I need a formula for the following condition:
If text equals (word) then enter 1, if text equal (word 2) then enter 0
This is the formula I tried to used but...
|
May 6th, 2010 03:43 PM
by ART
|
3 |
214 |
|
|
how to apply Warning massage by
deepak
how to apply Warning massage so that a wrning massage should pop-up while
comparing two mismatched values
|
May 6th, 2010 03:28 PM
by dlw
|
2 |
213 |
|
|
Count of numerical values within a cell by
Sasikiran
Dear,
I am looking for a formula which counts only the numerical values within a
cell ignoring the special characters, text and anything else and gives the...
|
|
5 |
287 |
|
|
Data validation by
Brad
Can data validation be set up to accept a 0( (zero) or any whole number
between 25,000 and 10,000,000? Or does this have to be controlled with VBA?
This...
|
May 6th, 2010 02:55 PM
by Brad
|
2 |
197 |
|
|
Extracting Dates by
dwake
I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the
format of ddmmmyy. I am trying to create two more columns of data, one
containing...
|
|
4 |
209 |
|
|
|
|
2 |
220 |
|
|
Convert Date string to date format by
Joe M.
I have some date strings I need to convert to date format. For example im
trying to convert strings like "200910" to Oct-2009. I tried using something
like...
|
|
7 |
351 |
|
|
merge cells without losing data OR format by
johncaleb
Need to merge A1 with B1.
Critical to retain the format of each cell.
A1 has text that is Left Justified.
B1 has text that is Right Justified.
Need the...
|
|
2 |
301 |
|
|
|
|
2 |
205 |
|
|
|
|
1 |
194 |
|
|
Excel Drop Down lists by
Marta123
I've created a spreadsheet with a drop down list, however, i want the user
to be able to select an from a list of options, which would then poplulate
the...
|
|
1 |
186 |
|
|
Re-post: How to maximize the Excel window? by
Eric
I set schedule to open excel file, when it opens, the excel window's size is
not maximized, and I have tried your approach, for manually opened
approach, it...
|
|
3 |
249 |
|
|
Move all page contents to another page - how? by
Martin ©¿©¬ @nohere.net
Hi
I have a workbook with 14 pages
I add page 15 & 16 which are blank
How do I move all of page 14 (contents, page layout, formating,
headers/footers...
|
|
2 |
249 |
|
|
Sumproduct Dynamic Range - XL2003 by
Nate
I have a sumproduct formula(s) that is calculating very slowly in my
workbook.
=SUMPRODUCT(((Data!$D$2:$D$10000=$E22)*(Data!$A$2:$A$10000='H-Code SS...
|
|
3 |
244 |
|
|
comparing 2 data by
reza
Dear All,
i have a master data from client and my data from data entry. Now i want to
compare from both data.
ie,
sheet1 (master data from client)
Names ...
|
|
7 |
232 |
|
|
|
May 6th, 2010 07:22 AM
by Kawboy
|
2 |
226 |
|
|
File set up query. by
ckb1980
Can i set up an excel file to open automatically on pc start up?
|
|
1 |
172 |