Remove hyperlinks in Excel

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:      • file://     • news:       • \\ Excel also creates a hyperlink when you type an e-mail address in the following […]

RIGHT() Function in Excel

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 specifies the number of characters you want RIGHT to extract. Remarks Num_chars must be greater than or equal to zero. […]

LEFT Function in Excel

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 contains the characters you want to extract. Num_chars specifies the number of characters you want LEFT to […]