Delete all hyperlinks on a sheet in Excel 2003/XP/2000/97

: I’ve had a hyperlink problem in my Excel files for ages: false hyperlinks had crept in (even in empty cells) and were multiplying regularly whenever I inserted new lines. How can I delete all hyperlinks in a sheet at once and not have to delete them cell by cell?

Php generate random numbers

/*random function $length: length of needed number */ function random($length) { $hash = ”; $chars = ‘0123456789′; $max = strlen($chars) – 1; mt_srand((double)microtime() * 1000000); for($i = 0; $i < $length; $i++) { $hash .= $chars[mt_rand(0, $max)]; }

Remove hyperlinks ( A tag) from HTML

Sometimes we want to remove hyperlinks with anker text, sometimes only keep anker text, how to use php to achive this? First, only remove hyperlink, and keep anker text part, the code is: $text = ‘Test paragraph.’;


— Renames a file or directory Description bool rename ( string $oldname , string $newname [, resource $context ] ) Attempts to rename oldname to newname .

fwrite() example

Description int fwrite ( resource $handle , string $string [, int $length ] ) fwrite() writes the contents of string to the file stream pointed to by handle .

how to use php generate passwords

Here are 2 kind php code can generat strong passwords: $password_length = 9; function make_seed() { list($usec, $sec) = explode(’ ‘, microtime()); return (float) $sec + ((float) $usec * 100000); } srand(make_seed()); $alfa = “1234567890qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM”; $token = “”; for($i = 0; $i < $password_length; $i ++) { $token .= $alfa[rand(0, strlen($alfa))]; } echo $token;

Hide your Affiliate Links using PHP file

If you want to make more money and profit from your affiliate links, you need to display them in different way. Don’t use the default link generated by your affiliate program script. Instead, hide it by using PHP file.