All Questions
Tagged with microsoft-excel worksheet-function
7,327
questions
15
votes
3
answers
74k
views
What Excel formula can I use to calculate the 2nd Monday of a given month?
What Excel formula can I use to calculate the second Monday of a given month?
You can assume I have a cell containing the first day of the month to work with.
In the interests of other users, can ...
- 3,061
15
votes
5
answers
432k
views
How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?
I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
- 153
14
votes
4
answers
197k
views
Is there an Excel formula to identify special characters in a cell?
We have about 3500 documents whose filenames need to be manually scrubbed to remove special characters like brackets, colons, semicolons, commas, etc.
I have a text file that I've dumped into excel, ...
- 1,799
14
votes
3
answers
84k
views
Excel: Replace occurences of one character with another in a String?
I want an excel formula that will change Haverford, PA to haverford,+pa. (Text is to lowercase, and spaces are replaced with plus characters.)
The following will get the first space, but not all of ...
- 1,622
14
votes
1
answer
23k
views
Switch Calc (or Excel) formulas to English language
I'm not using an American/English version of Calc/Excel so, every time I want to post here (or on other "web-places") or when I want to try formulas posted by others I need to "translate" them somehow ...
- 2,006
13
votes
3
answers
25k
views
How do I append a character to the end of every line in an Excel cell?
I have a column of Excel cells that's similar to a grocery shopping list and looks as follows:
3 Days Ingredients
2 Apples
1 Jug of milk
3 Bags of mixed vegetables
5 Potatoes
Is there a way to ...
- 241
13
votes
5
answers
104k
views
AutoFill Large Number of Cells in Excel?
I have a formula in Excel that I would like to autofill to 999,999 other cells. How can I do this without dragging the autofill handle down the entire sheet?
- 139
13
votes
5
answers
65k
views
Merging columns in Excel with ";" separator
This is my raw data in excel in different row and cells:
A B C D E F
1 2 3 4 5 6
2 3 4 5 6 7
3 4 5 6 7 8
I would like to convert all data into this format ...
- 131
13
votes
3
answers
159k
views
How to keep random numbers from changing in Excel?
I am trying to generate a set list of random numbers between 1 and 5 using the RANDBETWEEN formula.
I'm running into a problem that every time I click another cell anywhere in the sheet or even open ...
- 281
13
votes
5
answers
18k
views
Custom user function without using VBA
Is it possible to create a custom user function in Excel without using VBA?
My problem is I have a long string of standard excel functions strung together to make one very long function.
This function ...
- 373
13
votes
4
answers
60k
views
What is a formula to remove the whitespace from an Excel cell when trim doesn't work?
I have a table of Excel data that I copied from an html table in Internet Explorer. A column of table values all seem to have a space at the end of them, but Trim won't remove it. When I paste-special ...
- 3,061
12
votes
2
answers
27k
views
How to generate random string from a set of available strings in Excel?
I want to generate a column which will have random string values in any order. Those string values have to be from ('New', 'Mint', 'Very Good', 'Good', 'Acceptable', 'Poor') strings? Can anyone let me ...
- 221
12
votes
3
answers
399k
views
Searching for a value in Excel, returning yes or no
I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...
- 121
12
votes
5
answers
13k
views
Is it possible to get the sheetname?
How can I get the sheet name in a cell? (I have more than one sheet, I want to get the current on each sheet)
- 5,774
12
votes
2
answers
178k
views
How can I ignore zero-values in an Excel graph?
I have built a template in Excel that organizes data and shows a graph. The graph plots two fields, Var1 and Var2, on the vertical against year along the horizon. Both Var1 and Var2 are pulled from ...
- 231