Add Your Doubts: Click Here
Summary: In this class, you will learn The Excel TEXT Function is used to convert numbers to text within a spreadsheet. Essentially, the function will convert a numeric value into a text string. TEXT is available in all versions of Excel.
Formula:
=CONCAT or CONCATENATE ( text 1, text 2)
Space in between 2 words: =CONCAT or CONCATENATE ( text 1, space, text 2)
‘-’ in between 2 words: =CONCAT or CONCATENATE ( text 1, ‘-’, text 2)
Left : =LEFT(select text, number of characters)
Right: =RIGHT( select text, number of characters)
Find: =FIND(find text, within the text, start number)
Mid : =MID(text,start number, number characters)
Length : =LENGTH(text)
Trim : =TRIM(text)
Search: =SEARCH(text)
Lower : =LOWER(target data)
Upper : =UPPER(target data)
Proper : =PROPER(target data)
Conclusion: In this class, you learned the Excel TEXT Function to convert text to numbers.
