963 reputation
47
bio website
location Front Royal, VA
age 33
visits member for 4 years, 3 months
seen Oct 21 at 20:33

Apr
15
comment How to use Advanced Editing in Notepad++ or similar
Your question is vague. You give the tool you have (Notepad++) and samples of the text you want to edit, but you aren't clear on exactly what you're trying to accomplish. In order to automate a process, there has to be something true of the parts to be changed that is not true of the parts that must remain unchanged. What is this for your example?
Apr
15
suggested suggested edit on How to use Advanced Editing in Notepad++ or similar
Apr
8
comment When pasting, how can I ignore hidden columns in the destination range?
In case somebody wants the AHK solution: gist.github.com/Fluffums/10162893#file-ahk-literaltabpaste-ahk
Apr
8
comment When pasting, how can I ignore hidden columns in the destination range?
I've run into this scenario before as well. In my case, I was pulling data from a source, and running equations on columns I had inserted. I want to be able to paste updated data into the appropriate columns by hiding the equation columns.
Apr
7
comment How can i fix the mean of a column of randomly generated values?
No. =rand()*2 might be what you're looking for, but it won't "always" be 1.
Apr
7
comment When pasting, how can I ignore hidden columns in the destination range?
You inspired me to write an AutoHotKey script to handle this situation. Are you interested in an AutoHotKey solution? Or is that too far out of the scope of this question?
Apr
7
comment When pasting, how can I ignore hidden columns in the destination range?
This would seem like a common enough operation, once you start making use of hidden columns and rows.
Mar
26
answered Can MS Excel use non-printable characters as field separators in CSV files? If so, how?
Mar
26
comment Can MS Excel use non-printable characters as field separators in CSV files? If so, how?
I've added an explanation for how to do it with vanilla Notepad. If there is a built-in way to change the CSV separator, I'd love to hear about it. This method is definitely not something I'd be happy to perform, especially with any regularity.
Mar
26
revised Can MS Excel use non-printable characters as field separators in CSV files? If so, how?
added 435 characters in body
Mar
25
answered Can MS Excel use non-printable characters as field separators in CSV files? If so, how?
Mar
19
suggested suggested edit on match all strings containing only one '/' character
Mar
18
answered Batch filling pdf form using data from Excel
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?