4,811 reputation
62462
bio website alaskadataconsultants.com
location Fairbanks, AK
age 48
visits member for 4 years, 11 months
seen Jul 2 at 16:45

Control Systems Engineer.

Most people want to stick their head in the sand and ignore problems, in an effort to avoid conflict. I refuse to be that passive person. Problems are there to be fixed, which means that first they have to identified. Denial is not just a river in Egypt.


Sep
22
comment How can I create a reusable function in Excel 2007?
This is called a UDF, user-defined function.
Sep
22
revised How can I create a reusable function in Excel 2007?
edited tags
Sep
22
revised How can I create a reusable function in Excel 2007?
added 89 characters in body
Sep
22
answered How can I create a reusable function in Excel 2007?
Sep
22
revised Excel string extract
edited tags
Sep
22
revised Excel string extract
edited tags
Sep
21
revised Why does my computer erratically scroll up and down?
edited tags
Sep
21
revised D-LINK Wireless and Eset Smart Security
edited tags
Sep
21
revised What's the most popular portable applications manager?
edited tags
Sep
21
revised Free app with outlining as good as WordPerfect?
edited tags
Sep
19
comment How to install Windows 7?
There are a few layers of ignorance shown in your comment, that show a lack of experience, and inattention to what was actually said.
Sep
18
comment Is “Windows Tax” a valid and fair term?
The reason Apple doesn't have the dominant OS is because of their tighter coupling. They went the proprietary route and lost their dominance.
Sep
18
answered How to install Windows 7?
Sep
18
comment How do you get the Firefox Auto-Refresh to hold off when you're entering text?
Thanks, I have mine set for 1 minute, hopefully that doesn't cause any problems.
Sep
17
revised hamachi like software for Snow Leopard?
edited tags
Sep
17
comment Best way to remove leading zeros from a non-numeric value in Excel
@Chris, I can do it if we know the max number of zeroes that will ever appear embedded in the string, or trailing after (though it will be a long formula).
Sep
17
comment Best way to remove leading zeros from a non-numeric value in Excel
Yes, you'd have to use TRIM for the spaces, unfortunately, EXCEL doesn't have an LTRIM function, which would solve everything.
Sep
17
comment Best way to remove leading zeros from a non-numeric value in Excel
Actually, that only saves one zero on the end, if there's multiple trailing zeroes, then that doesn't work.
Sep
17
comment Best way to remove leading zeros from a non-numeric value in Excel
Yes, but when the CHAR(9) was added (to each zero), it added itself to the leading zeroes also. I see that you only used it to save the trailing zeroes and I'll incorporate it into the answer.
Sep
17
comment Best way to remove leading zeros from a non-numeric value in Excel
The CLEAN function saves the embedded spaces, but also saves all but the first leading space.