how to join two table in codeigniter easily[updated] | ci_model | ci_controller | codeigniter 3 -datainflow
Excel Text Function
Excel has thousands of formula. Text formula is most common function in excel. with text formula, we can work with non numeric values. here I share some daily use text function. Please follow us for more amazing excel tips & tricks.
List of Text Function
Char Function
- 🎯 Purpose: Get a character from a number.
- 🔣 Functions: =char(number)
- ➕ Parameters / Arguments: A number between 1 and 255.
- ↩️ Return Value:A single character is specified by a number.
- 📑 Points
- If number is out of range, CHAR returns #VALUE!
- If number is not numeric, CHAR returns #VALUE!
- Number must be between 0 – 255.
- Used specially where impossible to write text into the formula & function.
Code Function
- 🎯 Purpose: Get the code for a character.
- 🔣 Functions: =code(text)
- ➕ Parameters / Arguments: The text for which you want a numeric code.
- ↩️ Return Value: A numeric code representing a character.
- 📑 Points
- The text contains many letters, Code function only returns the first numeric code.
- The CODE function will handle numeric input for the numbers 0-9.
♻ CLEAN Function
- 🎯 Purpose: Strip non-printable characters from text.
- 🔣 Functions: =clean
- ➕ Parameters / Arguments: The text to clean.
- ↩️ Return Value:Text with non-printable characters removed.
- 📑 Points
- Clean function removed all not printed character ASCII standard.
💲 DOLLER Function
- 🎯 Purpose: Convert a number to text in currency format.
- 🔣 Functions: =dollar(number, decimals)
- ➕ Parameters / Arguments:
- Number: The number to convert.
- Decimals: The number of digits to the right of the decimal point. Default is 2.
- ↩️ Return Value: A number as text in currency format.
- 📑 Points
- The name of the function and the currency symbol used is based on the language settings of the computer.
- It’s important to understand that DOLLAR returns text and not a number, so the result cannot be used in a numeric calculation.
- Decimals is optional and default to 2.
- The DOLLAR function converts a number to text using currency number format: $#,##0.00_);($#,##0.00).
- The default for decimals is 2. If decimals are negative, the number will be rounded to the left of the decimal point.
➕ Concat Function
- 🎯 Purpose: Used for concatenates or joining text strings.
- 🔣 Functions: =concat(Text1, Text2)
- ➕ Parameters / Arguments:
- Text1: Text to join
- Text2: Text to join.
- ↩️ Return Value: Always return the join text string.
- 📑 Points
- The text parameter might be a cell reference.
- Support up to 254 text strings.
If you need more in-depth text based tutorials, please comment below. i will create a blog for you. Thank You so much for reading. Subscribe us
Related posts