Reputation
1,063
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 10
Newest
 Custodian
Impact
~93k people reached

Mar
16
comment Excel - Get rid of extra space in cell when using Text Wrap
I've encountered the same thing in 2010. No sure fire solution yet, but zoom levels have sometimes made it look worse.
Mar
12
answered Stubborn “Read-only” notification in Excel won't go away
Mar
12
revised Stubborn “Read-only” notification in Excel won't go away
Apparently this is a really boring title. Maybe I can spice it up.
Mar
11
asked Stubborn “Read-only” notification in Excel won't go away
Mar
10
comment Excel - Get rid of extra space in cell when using Text Wrap
Clarification: does this happen when your zoom is at 100%? Or only when you're zoomed in/out?
Mar
2
comment Can't compare a cell to a column in excel
What's your formula? Perhaps post the formula in your question. Why doesn't vlookup() with a final parameter of FALSE work for you?
Feb
27
comment Word 2010 - What is the unknown character displayed as a number?
Seeing the symbol here would definitely be helpful. There's a decent chance that the mystery updater has a font that you do not. Any chance these mangled words were being given special formatting?
Feb
26
comment How to sort this list in excel?
That's a useful pattern for many situations where you are taking data that is formatted for reading and want to make it a sortable/filterable table. "Paste Values" is a key feature to know in Excel.
Feb
25
revised Can't compare a cell to a column in excel
added 109 characters in body
Feb
25
answered Can't compare a cell to a column in excel
Feb
14
answered What are these strange characters?
Jan
28
awarded  Yearling
Jan
27
answered Define value of a column by another column in Excel
Dec
23
comment Problems opening sharepoint document, checked out, but opening from temp folder instead
@LasseV.Karlsen, did you get this figured out?
Nov
26
comment Writing a Simple AutoHotkey Script (press a key every X second on desktop)
Is this to keep a remote desktop session open?
Oct
16
comment Is there an Excel formula to identify special characters in a cell?
I do want to point out that you're probably using the wrong tool for this. I can think of a couple ways of doing this pretty quickly in Notepad++, for example. You could even import the results into Excel at the end and have a column of 1s and 0s.
Sep
27
comment How to open huge PNG image
This is getting further afield, but you could convert it to a tif: libpng.org/pub/png/apps/ptot.html
Sep
27
comment How do I make Excel recognise TRUE or FALSE text as boolean values?
@Abbie What are you copying from? Copying "TRUE" and "FALSE" from a plain text file into Excel 2010 works with =INT(), even though it's formatted as General.
Sep
27
answered How to open huge PNG image
Sep
27
comment Calculating difference between 2 times, excluding weekends, then averaging the results
@Jill, barry houdini's new "Alternative Solution" will correct for the odd behavior of =NETWORKDAYS(). You really probably need to do two columns, one using the pretty format that includes the text, and another that just has a simple time value in it. Use the simple time value for your average.