Posts

content to stay long on its pages

Being a Blogger is not only about writing quality content anymore, but it's also about implementing the best SEO practice, adding more value and social touch and do many more tasks. As all the bloggers have realized recently after the Google Penguin update. The importance of SEO has itself increased. There is an obvious need to change our view to SEO. And why not learn from the only website that ranks 1 for almost 99% queries. Yes, you guessed it. It is Wikipedia, the largest online encyclopedia. Whenever you want to learn some new words. Wikipedia is the place. There is no doubt, Wiki SEO is out of the box and they take care of each part of site SEO structure carefully. For us (Bloggers and SEO's) Wikipedia is a good case study to learn and understand what an effective SEO is. There are a lot of ways in which Wikipedia retains its online quality. But, it doesn't even use so much 'secret' SEO tips that you cannot figure out. Here, I have listed the SEO tricks us

characters in a string with another set

You may have a workbook which contains text but you only want to extract certain characters from it. For example, you may only want to extract the first name from a cell which contains the first and last name of a person. In this tutorial I will show you how to manipulate text and in particular, I will show you some great techniques on how to remove the first 4 characters in Excel using the following functions: 1) Excel RIGHT Function 2) Excel MID Function 3) Excel REPLACE Function Using the Excel RIGHT Function In this example I want to remove the first 4 characters from the postcode CV36 7BL and leave the last 3 characters. Let's assume the postcode is in cell A2 in the Excel spreadsheet. The formula in cell B2 will be: =RIGHT(A2,LEN(A2)-4) So how does this formula work? Let's break this down so you can understand how it works. RIGHT Function The RIGHT function extracts a given number of characters from the right side of a specified text. For example =RIGHT("ba