Category: Excel

To find special character in excel cell and place a remark if found, you may use the formula below:...

Scenario (Applies to MS Excel) When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel automatically creates a hyperlink: • http://     • www.      • ftp://     • mailto:      •...

Suppose that you have a workbook that contains lists on a large number of worksheets and that you want to change the name of each worksheet to match the heading of the list on that worksheet. Not every worksheet has a list on...

Now that you know something about how Microsoft Excel 2010 exposes its object model, you can try calling object methods and setting object properties. To do so, you must write your code in a place and in a way that Office can...

Using Code to Make Applications Do Things You might think that writing code is mysterious or difficult, but the basic principles use every-day reasoning and are quite accessible. The Office 2010 applications are created in such...

RIGHT returns the last character or characters in a text string, based on the number of characters you specify. Syntax RIGHT(text,num_chars) Where: Text is the text string containing the characters you want to extract. Num_chars...

The LEFT function is helpful if you want to return the first character or characters in a text string from the left, based on the number of characters you specify. Syntax LEFT(text,num_chars) Text is the text string that...