Posts

Remove Paragraph Marks / Carriage Returns

I'm sure you've received an email from time to time that you need to save in Word or publish online, and there were carriage returns every line as if it was entered using a typewriter (you remember those). It can be very time consuming to manually delete each Carriage Return on every line. But thanks to a Word Macro, the job is easier. Note that once they are all removed, you still need to re-enter the appropriate paragraph marks.

Create a new Macro and use code:

Sub NameOfMacro()
For Each Xpara In ActiveDocument.Paragraphs
Xpara.Range.Select
Selection.Characters(Selection.Characters.Count).Delete
Next
End Sub

After saving, run the macro.

2010 Tech Predictions

2009 was a very difficult year for our economy, and many friends and colleagues lost their jobs and/or their homes. While I can't very well predict how our economy will do in 2010, I will try to out due my 1 for 3 predictions of 2009 with my 2010 predictions. In no particular order, here are my 5 top tech predictions for 2010.
With the number of players increasing in the eBook Reader arena, Amazon will adopt the ePub format as a supported file format.The next version of the iPhone, announced this spring, will be available on Verizon.Similar to the data loss that occurred for Sidekick users in 2009, a significant data loss or corruption will happen on a Cloud platform. Though hopefully like with the Sidekick data being recovered, even if the data is recovered, it will send a strong message to CIOs and others considering moves to the Cloud.Depending on the reports you read, the browser war statistics can vary widely. Regardless, Internet Explorer continues to dominate, despite loweri…

2009 Tech Predictions Review

I made 3 rather tame (or lame) tech predictions for 2009 -- none with any real relevance. Here's a recap of how I did.
Apple will become less popular.
Miss. Though a very subjective opinion, here's what happened. Throughout much of 2009 there was a lot of buzz about an Apple Tablet that never materialized, but it kept Apple in the news. Early in the year there was also a lot of buzz about Steve Jobs' health and further whether he would return to Apple or not. Upon his return, as announced, the buzz has died down. Finally, Apple received some spill over from the new Verizon ads that really trashed the AT&T 3G network. To counter some of the Apple buzz, we started seeing several Android phones (finally) ship late in the year. Overall, I don't think the buzz, and therefore popularity, died down as much as expected. On the other hand, clearly Apple was no where near as popular as they had been the two prior years with the iPhone.TWiT will lose its spot as the top tech po…

Count the number of Rows after Auto-Filter in Excel

When you first apply an Auto-Filter in Excel, the Status Bar indicates the number of records in the filter (e.g. 517 of 8614). In many cases when you start performing other manipulations, the number disappears. Using a simple formula, you can calculate the filtered total.

Assume you want to count all rows that are not empty -- the CountA function -- and assume you want to count the rows in column A. The formula would be SUBTOTAL(103,A:A)-1. The syntax is as follows: subtotal(function_number, reference), where function_number is 1 of many possible options as illustrated below. I included the "-1" to remove the count for the column heading row.
function_num
(includes hidden values)function_num
(ignores hidden values)function1101AVERAGE2102COUNT3103COUNTA4104MAX5105MIN6106PRODUCT7107STDEV8108STDEVP9109SUM10110VAR11111VARP
Note: I used Excel 2003 for this example.

Increase IIS on XP Maximum Connections

With increasingly more complex web pages, I found myself running into a limit in the number of IIS connections allowed for the constrained web server on Windows XP. By default Microsoft has limited the connections to 10. Even when I changed the time to release connections down to 5 minutes, I was still running into problems. With a little Google searching, I found a solution (here, here, and here).

Apparently the hard-coded limitation Microsoft has set is 40 connections. The trick is determining how to raise the level from 10 to 40. There's a script, adsutil, that can do this for you.
Go to the Command Prompt and navigate to C:\Inetpub\AdminScripts.Enter "adsutil set w3svc/MaxConnections 40".If you get an error message, "This script does not work with WScript," click OK and click Yes to make Cscript as the default script for VBscript.When this completes, go back to the Command Prompt and press F3 (repeats last command) and Enter.If you were successful, the comman…

Love @ First Website 2009 notes

Image
For the last five years iSiteDesign has been hosting Love @ First Website (#LFW). It's a half-day event where you get to listen to 3 or 4 speakers share about their business and their website and/or web presence. I've attended 3 of the 5 events and have always taken away a few nuggets. This years theme was "Dare to Delight." My notes follow.

Carri Bugbee
Owner of Big Deal PR; Instructor of Social Media Marketing at Portland State; and ghost tweeter as Mad Men's (AMC) Peggy Olson (@peggyolson) Twitter @peggyolson Lessons:
1. Get there first
2. Stay on message
3. Always listen first
4. Admit when you're wrong; Give credit due
5. Build community; everyone wants to be acknowledge.
6. It's a real job; it's a real tool (i.e. It takes time and effort to have a Twitter/social presence)


Paul Zaengle
Sr. Director of eCommerce, Columbia Sportswear
Columbia Sportswear basics:
1. Make Brand the #1 Focus
2. Be Truly Multi-channel (Zipcar demonstrated this)
3. Think Like a Custom…

Exclude Websites in Your Searches / Custom Searches

Image
I've been doing quite a bit of research lately on technical topics, where the results would frequently include results from a pay site, Expert Exchange. If you;re familiar with Expert Exchange, they've been very successful in getting their pages to return high in the list of Google results. I have found it very frustrating when I inadvertently click-through on one of their pages.

With a little research, I found that Google has a custom search option, where you can include and exclude certain websites. I have created a custom search that includes all Google results with the exception of Expert Exchange. To make it really useful though, I needed it to be in my search bar in Firefox, which I use almost exclusively for new searches. I found a Firefox Add-on to do that too.

Here's how you can make your own custom search.
If you don't already have one, you must have a Google account.Go to the Google Custom Search page and click "Create a Custom Search"

I had to start w…