WebCitz Blog


Fine Blood

The WebCitz team is pleased to announce the launch of their latest project, the Fine Blood website! FineBlood™ is a spray designed for hunters to help track wounded game after shooting. This spray was developed from the concept of forensics used by law enforcement in crime scene blood detection. Be sure to check out Fine Blood online to see the new website design and ecommerce development!


Google AdWords Coupon

If you are looking to start a new paid search marketing campaign with Google then you might be interested in taking advantage of a current offer they have for $75 worth of free credits after you spend $25. You can learn more at http://www.google.com/ads/adwords-coupon.html


Cardinal Path Webinar on WASP for Chrome

WebCitz is excited to be attending a Cardinal Path webinar at 12:30pm CST about WASP (Web Analytics Solution Profiler) for Chrome. WASP is a free browser plug-in that is a must-have tool for analysts, marketers and developers. With WASP you can identify all the tags on your site, understand how and where they are firing, examine the content of each and understand how to optimize these to improve site load, easily identify and debug complex code, and much more. Cardinal Path will be offering a high-level walk through to show us what the value and benefits are and share how marketers, analysts and developers can leverage the tool to drive business improvement. Best of all, WebCitz will receive a link to an early release version of the tool! As most of you know, we were in San Francisco, CA USA back in July for an entire week soaking in a lot of great knowledge from Cardinal Path’s instructors! Learn more at http://webanalyticssolutionprofiler.com/.


Excel Tip / Trick: How to Check for and Remove a Trailing Comma

If you have ever worked with a spreadsheet that had lots of data – perhaps thousands or tens of thousands of rows – then you know the importance of formulas. We would like to share a handy formula with you that will check a cell for a trailing comma (or other character) and remove it. Please keep in mind that this formula actually checks to see if the last character is a comma – it will not just remove the last character in the cell no matter what – a crucial check for anyone that might not have such a problem on all cells.

=IF(RIGHT(A1,1)=”,”,LEFT(A1,LEN(A1)-1),A1)

In the above formula, you will notice that cell A1 is being checked to see if there is a comma at the last position. If a comma is found then it will remove the comma, but if another character is found it will leave it alone. To change it from a comma to another character, such as hyphen, simply change the formula to look like the following:

=IF(RIGHT(A1,1)=”-“,LEFT(A1,LEN(A1)-1),A1)

We hope this comes in handy for someone! Please remember to always keep backups of your files and data before making any changes!


Peyton Receiving a Pep Talk

Corey and PeytonHere is a great picture from within the office last Friday, featuring Corey giving Peyton a pep talk before the big game this past Sunday. As you might know, this pep talk must have been beneficial since it supposedly helped Peyton and company beat out a team whose quarterback threw for over 500 yards with 5 touchdowns, breaking franchise records and entering into an elite select group of quarterbacks. It should be known that we are a pro Green Bay team – we just like to have fun with the Fat Head!