Joining Two Text Columns in Excell

How can he merge First Name and Last Name into a single column?



Start with a basic formula of  =A2&B2 This will give you the result shown in C2 below:



If you want to change the name to proper case, use the =PROPER() function.  =PROPER(A2&" "&B2)



When your mouse pointer is near the dot, the mouse pointer changes to a cross like this.

Double click and the formula will be copied down to all of the cells in the range.



The TEXT function requires two arguments. (To display Date in formula)

Encoding and Decoding in ASP.net

Encoding: 

encodedUrl = Server.UrlEncode(urlToEncode)

Decoding:

decodedUrl = Server.UrlDecode(urlToDecode)