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

removing duplicates in exceldir function in vbahow to use hlookup functionexcel dashboard torrentddl and dml commands in sql servervba excel savelookup excelaction item log template excelunhide sheets in excel 2007excel 2010 lookup functionlimitation of vlookupexample of sumifs in excel 2010vba programs excel examplesvba code to open excel file from folderexcel formulas list 2007excel vba cells selectcolor by code worksheetsremove password from excel workbook 2010beginners sql tutorialmicrosoft excel vlookup functionwriting excel macros with vbahyperlink codinghow to make a pivot table in excel 2013excel vba data entry formhow to use vlookup in excel 2010 step by steplearn vba for accessgantt chart templates excelexcel adding rows formulavba read cellhow to unhide cells in excel 2013free project costing template excelexcel pivot grapheasy vbavlookup tutorial in excelslicer excel 2010 tutorialexcel vba delete selected rowsmerge cells in excel 2010option buttons in excelabsolute reference excel shortcutmacro to copy and pasteddl dml dcl commands in sql servervb6 calculatorexcel color index chartshortcut keys for excel formulasvba array of stringswhat does vlookup mean in excelsample vba code for excelsql quiz for interviewexcel vba undosubstitute vbawhat is adodbwhat is countif in excelexcel programming for beginnersmacros and vba in excelexcel unlock celledit excel macroslearn vba in excelhow to edit hyperlink in excelvba sheet cellscopy sheet to another sheet vbaexample of a vlookup formuladml languagepl sql connect to databaseexcel password sheetunlock vba project passworduse of offset function in excelexcel line chart tutorialexcel usedrangecopy entire excel sheetexcel 2007 macro securityexcel vba do until loopbreak excel vba