The free guide

CONCATENATE function in Excel

Use CONCATENATE, one of the text functions is used to join different text strings to a single string. A string may be a text value, number and cell reference. Syntax =CONCATENATE(text1, [text2], …) where, text1 is the first string that can be a text value, number and cell reference and text2, … are additional strings to join, you can […]

Absolute Values (ABS function) in Excel

Use ABS function is used to turn negative values to positive one or find the absolute value of a number. Syntax =ABS(number) where the number is a cell reference with a real number of which you want the absolute value. Example To convert above mentioned real numbers to absolute values, do the following steps: 1.  Select B1 […]

TRIM function

Use TRIM function is used to remove irregular spaces between words which may appear while importing data from another application. Syntax =TRIM(text) where text (argument) means that any information in a worksheet from which you want to clean from unwanted spaces. Example 1. Select cell B2, next to the cell A1 with irregular space.  2. Type =TRIM(address of […]

CLEAN function in Excel: Use, Syntax and Example – Explainry.com

Use CLEAN function is used to remove non-printable characters, which may appear when you import text from other applications. Syntax = CLEAN(text) text (argument) means that any information in a worksheet from which you want to clean from non-printable characters. TRIM vs CLEAN function Although both functions used to remove extra characters, however, there is […]

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved