Excel Text Functions:

Explained with Examples.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

  • PROPER: PROPER is a Logical Function. PROPER Function in Excel returns the first letter in a text string or cell references of every word as a capital letter and all other letters in the string are converted to lowercase.
  • UPPER: UPPER is a Logical Function. UPPER Function in Excel Converts all lowercase letters in a text string or cell reference to uppercase.
  • LOWER: LOWER is a Logical Function. LOWER Function in Excel Converts all uppercase letters in a text string or cell reference to lowercase.
  • FIND: FIND is a Logical Function. FIND Function in Excel returns the location or position of a sub-string in a text string.
  • CONCATENATE: CONCATENATE is a Logical Function. CONCATENATE Function in Excel is used to combine text from two or more cells into one cell.
  • SUBSTITUTE: SUBSTITUTE is a Logical Function. SUBSTITUTE Function in Excel replaces old text with new text, in a text string or cell reference.
  • REPLACE: REPLACE is a Logical Function. REPLACE function replaces a sequence of characters/words in a string with another set of characters/words
  • LEN: LEN is a Logical Function. Returns the length of the specified string.
  • REPT: REPT is a Logical Function. REPT function returns a repeated text value a specified number of times
  • VALUE: VALUE is a Logical Function. VALUE function helps to convert a number in a text format into a number format.
  • TRIM: TRIM is a Logical Function. TRIM Function in Excel removes unwanted spaces whether they occur between words or at the beginning or end of a string, except for single spaces between words.
  • CHAR: CHAR is a Logical Function. CHAR Function in Excel returns the last or right most character(or Characters) in a text string.
  • RIGHT: RIGHT is a Logical Function. RIGHT Function in Excel returns the last or right most character(or Characters) in a text string.
  • LEFT: LEFT is a Logical Function. LEFT Function in Excel returns the first or left most character(or Characters) in a text string.

Related pages

adodb connection objectunprotect excel sheet 2007vb filecopyexcel hlookup tutorialtable of contents worksheetspassword protect excel 2007 workbookfso file system objectif na vlookupunprotect xls filedatediff excelwhat does it mean to merge cellswriting excel macros with vbasql interview questions pdfresource planning spreadsheet templatecountif formula excelduplicate values in exceladvanced excel macro tutorialvb6 open text fileexcel macro waitnew adodb.connectionvlookup case sensitivehow to add developer tab in powerpoint 2010excel vba sqlsyntax worksheetsclose excel in vbadeveloper tool in excel 2007project management timeline excel templatehow to use iferror function in excelmultiple if excel formulavba tipscolorindex excelmerge cell in excelmicrosoft excel template downloadsexcel developer modecolorindex excel 2013vba scripting filesystemobjectlooping excelvba excel pastespecialsql important interview questionsgantt chart template word 2010excel insert pivot tablehyperlink to excel worksheetexcel command buttonsaccess vba open excel fileexcel macro row countexcel programming commandsmerge tabs excelvba do until loopexcel macro file locationvlookup with choose functionvlookupfunctionvba case statement accessexcel vba programming ebookinstr functionhow to delete duplicate data in excelexcel vba unprotect workbook without passwordunique records exceliif excelexcel consolidate toolgantt chart template powerpoint free downloadvba excel macros tutorialvba code msgboxaccess messageboxvba data entryconnect excel to sql databaseexcel activesheethow to add developer tab to the ribbondaily gantt chart excel templateexcel macro vbaautomatic row height excelinstr vbatrim formula in excelbasic excel macro examplesvba guidml dllactivate workbook