Change to Sentence Case in EXCEL

Change Uppercase to Title Case PROBLEM: You need to change UPPERCASE string/text to Title CaseSOLUTION: Use PROPER functionRESULT: FOLLOW ME TO STEP-BY-STEP GUIDE This tutorial will explain how to change your UPPERCASE text toTitle Case text! 1. Type your uppercase text. For example, I type “PLEASE, CHANGE THIS TO TITLE CASE” in cell B2 2. Move your cursor to other cell (for example, I move my cursor to cell B4. See below) 3. Type this in cell B4, “=PROPER(B2)” then press Enter. B2 are the cell containing text you want to change. 4. Then you will see the result! See below: Done !!! Sometimes, you’re not need UPPERCASE and formula anymore after you get the Title Case text version.  So you can copy ONLY the VALUE (“Please, Change This to Title Case” not “=PROPER(B2)” or uppercase version). For this, do following steps: 1. Right-click on cell B4, then click COPY. 2. Move your cursor to other cell (for this example, I move to cell B6) 3. Right-click on this cell, then click PASTE SPECIAL… 4. Choose options to VALUES in paste options, then click OK button Done !!! Now, you can delete other cells.   .

» Read more

Facebook Plugin for WordPress 1.0.3 Released

Link for Download : https://github.com/facebook/wordpress/zipball/master Version Change logs: = 1.0.3 = * Tweaks to copy to make things clearer. * Fixed issues with social plugins settings on indivial posts/pages. * Fixed issues with access tokens expiring, affecting posting to Facebook page and user Timelines. * Fixed issues with HTML markup appearing in stories posted to Facebook. * Fixed bugs in new user experience. * Fixed bug where Open Graph action was being posted to author’s Timeline, even though option was disabled. * Added option to disable “View Comments” on homepage. * Fixed comments SEO so that replies to comments also appear. * Moved CSS files to head. * Adding functionality to decode HTML entities in titles sent to Facebook. * Changed mention links on posts/pages to open in new window/tab. * Added nicer tooltips to the Facebook settings page. * Fixed showing faces and the send button so that they don’t display if they’re disabled. * When the plugin is removed, pertinent data is also removed so that there aren’t issues when re-installing the plugin. — Haneef Puttur *************** People May Not Believe What You Say.. They Will Always Believe What You Do .

» Read more

Automatically Ping Google Blog Search Engine – wordpress

Automatically Ping Google Blog Search Engine If you have a WordPress Blog, you can add the following URL in your Settings -> Writing ->Update Services. The default service here would be “http://rpc.pingomatic.com/“. Add another line the following URL and save your Settings. From now everytime you update your Blog, Google Blog Search would be ping automatically. http://rpc.pingomatic.com/ http://rpc.technorati.com/rpc/ping http://rpc.blogcatalog.com/ http://api.my.yahoo.com/RPC2 http://api.my.yahoo.com/rss/ping http://ping.feedburner.com/ http://rpc.blogrolling.com/pinger/ http://blogsearch.google.com/ping/RPC2 http://api.feedster.com/ping http://rpc.icerocket.com:10080 http://www.bloglines.com/ping — Haneef Puttur *************** People May Not Believe What You Say.. They Will Always Believe What You Do .

» Read more

WordPress Boldy Theme – Full Width Template

1. Under wp-content/themes/boldy, you should find a number of .php files, many of which are your page/post templates. Copy page.php and rename it as fullwidthpage.php 2. Edit the file in a plain text editor and change all of the text to look like this: 3. Save the file 4. Now when you login into your WordPress site and access the Editor, you should see this new template listed as Full-Width Page Template. If you don’t see this, you’ve done something incorrectly. 5. If step 4 works, you now need to edit Header.php file as well as Style.css 6. In Header.php, find this section and add in the text highlighted in yellow: > 7. In Style.css, find this section and add in the text highlighted in yellow: body#home #content, body#portfolio #content, body#fullwidth #content {background:none; 8. Now when you create a new page, just select Full-Width as the template and your page will appear without the sidebar and without the sidebar divider line. .

» Read more

Resetting WordPress Admin Password

How to reset my WordPress admin password? You have to do this through the WordPress database directly. The most convenient way to manage the database is via the phpMyAdmin tool at your web hosting account. Once in phpMyAdmin select the WordPress database from the drop-down menu on the left. The page will refresh and the database’s tables will be displayed on it. Open the SQL tab (look at the top navigation bar). In the text field write the following SQL query: UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password_here‘ ) WHERE `wp_users`.`user_login` = “admin_username“; “new_password_here” – replace this with the new password you wish to use.“admin_username” – replace this with the username the password should be updated for. Once you are ready, click on the GO button to submit the query. If everything goes fine without errors, you should be able to login to WordPress with the new password. .

» Read more
1 2 3