Substring Small strings inside a STRING. For example A STRING: “India is a Great Country” Substring can be India is India Great country Is a great So on…. You might want to extract the first few letters of a STRING. Excel gives you three functions for extracting substrings, as described in the next three sections. […]
Working with Substrings Read More »
Understanding Basics A formula is like a special code entered into a cell. It performs a calculation of some type and returns a result that is displayed in the cell. A formula always begins with an equal sign and can contain any of these elements: Mathematical operators Cell references Values or text functions After you
TODAY() function returns the serial number of the current date. This function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals. For example, if you know that someone was born in 1990, you might use the
The TEXT function let us change the way a number appears by applying formatting to it . It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. In its simplest form, the TEXT function says:=TEXT(Value you want to format, “Format
