Archive for category: Excel

Manipulate Strings With Excel – Add Characters

By

May 9, 2013

2 comments

Excel

Manipulate Strings With Excel – Add Characters

My goal is to turn the string http://google.com into “http://google.com/*” for over 800 different domains, which is way too many to do manually. There are several ways to manipulate strings in excel using the CONCATENATE function, which is well described in this tech republic article, but I will share the […]

Read more

 

Amazon S3 Log Analysis Made Simple With Excel

Amazon S3 Log Analysis Made Simple With Excel

It wasn’t straightforward finding an easy way to analyze my Amazon S3 logs. I unsuccessfully tried several instructions and services before arriving at the simple solution below. I looked into paid services like S3Log, S3STAT, and Qloudstat. I tried the free version of Qloudstat, until my logs quickly exceeded the “free” limit, […]

Read more