[video]http://www.youtube.com/v/dM3eECtmwqk[/video]A follow up to the first Excel video Excel Tips By Bloglyne – How To Set Up Clickbank Tracking Code – this video talks about the LEN function.

If you find this video helpful, make sure to subscribe to our blog for upcoming videos, we also look forward to your comments.

If you have a difficult time watching the video here, please go to YouTube and view it in a larger size there.

This is the second video in what I think will be a four video series on how to create subdomain tracking for use with the Google Content Network.  The next video will discuss the MID function and in the fourth video we will put it all together so you can see the mechanics of the spreadsheet which enables us to create all of the custom sub-domain links and information needed to populate Google’s content display ad network.  We will also make the spreadsheet available for download upon the release of the fourth video.

A very quick summary of features covered in the video:

• LEN returns the number of characters in a text string
• Once you LEN returns the number of characters

I hope you guys find this useful, please let me know what you think!

[video]http://www.youtube.com/v/3KORGsUcReM[/video]A little video about how to use Microsoft Excel to set up tracking code URLs for Clickbank with some tips on how to stop the formulas from auto-iterating when using the auto-fill handle feature in Microsoft Excel by using the $ operator in the formula.

If you have a difficult time watching the video here, please go to YouTube and view it in a larger size there.

The main reason for the video is that I was having a lot of difficulty yesterday getting this Excel spreadsheet to work the way I wanted it to, so I did some research and found the solution. I’m certain if I had difficulty figuring this method out, there are others out there who have had similar experiences. By recording this video, hopefully, I won’t have to “figure it out again” either – I can just come back here and be reminded how to do it *grins*

A very quick summary of features covered in the video:

• Use the & to append multiple cells together – for example: =c2&A4
• Use the $ to freeze a formula on one cell in the spreadsheet – for example =$C$2 to hold the formula on that cell while using the drag autofill feature in Excel

I hope you guys find this useful, please let me know what you think!