I ran into a problem today where I needed to replace the spaces in a field with their encoding for use in a URL.  After much searching it seemed that this was not as simple as it would first seem.  I did, however, come up with a solution, however ineloquent it may be.

The basics of how I did this to use a series of calculated columns each using the FIND and REPLACE functions in conjunction.  The easiest way to show this is with an example.  For the purposes of this example, the original text will be in the "Title" column.

The formula for the first calculated column titled "Encode1" looks like this:

=IF(ISNUMBER(FIND(" ",[Title])),REPLACE([Title],FIND(" ",[Title]),1,"%20"),[Title])

The formula for the second calculated column title "Encode2" looks like this:

As an engineer, Dilbert is one of my favorite comics and was one of my favorite television shows for the brief period of time it was on.

Official Dilbert Web Site: www.dilbert.com

Dilbert Animated Series:

This is a quick quick guide to referencing the preview page of a taxonomy term.

http://<yoursite>/taxonomy/term/1 - All the nodes directly categorized with term 1.

http://<yoursite>/taxonomy/term/1,2 - All the nodes directly categorized with term 1 and term 2.

http://<yoursite>/taxonomy/term/1+2 - All the nodes directly categorized with term 1 or term 2.

http://<yoursite>/taxonomy/term/1/3 - All the nodes categorized with term 1 or any of it's "children" to a maximum depth of 3.

http://<yoursite>/taxonomy/term/1/all - All the nodes categorized with term 1 or any of it's "children" with no maximul depth.

I was going to write a how-to, but then I discovered that a much easier way than I have been doing was documented here: http://support.microsoft.com/kb/934838.