Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

3
votes
6answers
4k views

Why is Excel 2010/2013 taking 10 seconds open any file?

I have a fast Windows 7 PC with two SSDs and 16GB of RAM, so I'm used to programs loading very fast. But recently, for no reason I can figure out, Excel has started taking way too long to open Excel ...
0
votes
5answers
2k views

Why do 2 excel (2003) files that are exactly the same have different file size?

I have two excel files that are exactly the same (in terms of the content of the file) but differ by quite a margin on file size. One file is 37.5 KB while the other is 56 KB. The only difference I ...
1
vote
4answers
67 views

Filtering character in Excel

I have a column in excel file which is mix of set of character and numbers, I want to filter out all rows starting with character. Example Column1 abc 12345 def 5678 xyz 7895 tryc I want to ...
0
votes
4answers
364 views

Excel how to count the number of same words/ strings in a excel file

I have an excel sheet with data in rows for example: aa aabbcc aa, aa aa aabbcc dd, dd ee So I am looking for an output like : aa = 4, aabbcc = 2 , dd=2, ee=1 .
0
votes
4answers
209 views

How to configure and move text in a raw text file including keeping spaces

What I need to do is move a column of text over to another part of the file; however, each line needs to be a specific amount of spaces at the end and I cannot copy the lone column over because it ...
0
votes
3answers
186 views

Finding multiple coded values in a string, then returning a lookup value for each found code

I have 600 item codes, and each one is coded with attributes in the overall item code. For example, we might have the plain item 600, then 600BK (Black body) and 600BKR(Black Body, Red colored detail) ...
0
votes
3answers
1k views

How may I retrieve data from an Excel table based on a variable number of criteria?

I have the following salary data for example: Country State 2012 2013 -> 2027 ======= ===== ==== ==== China Other 1000 1100 China Shanghai 1310 1400 China Tianjin ...
0
votes
3answers
856 views

Excel or Batch - Trying to Automate Text Correction (Many Changes; One or More Characters Each)

I have a lot of lines of text. I can put them into a text file or into an Excel spreadsheet. They need many changes. Here's an example of a before and after: Input: I'm buying one! Only ...
0
votes
3answers
1k views

Selecting all data in Excel column regardless of size

I have a repetitive process that I must do in Excel for test data collected. I have to do this process for every data point I collect. I collect over 200 data points each test. My data is auto ...
-1
votes
3answers
41 views

Excel Formula to match dates

This may sound really simple but I need a formula that checks if one column's date is the same as another, and if so put 'true' or '1' or something. I tried =IF(H2=G2, "True", "False") but it does not ...
-1
votes
3answers
954 views

How to find out if 2 cells contain texts/numbers

How do I come out with a formula which gives me... if cell A1 contains SOMETHING and cell B1 contains something, equate to "OKAY" and if cell A1 contains something and cell B1 is empty/blank, equate ...