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

vlook up examplehow to find difference between two dates in excelvb gotosample charts in excelmerging columns in excelcount function in ms excelprogramming macros in excelexcel vba chr functionvba application calculationvba create new foldervba for each worksheetworkbooks.close vbahow do you sort alphabetically in excelvba conditionexcel combo box in cellexcel worksheet columnshow do you unhide a column in excelsumif function examplesaccess vba selectexcel match formulauser input in vbahow to create sql query in excelhow to unlock an excel spreadsheet for editingarrays in vbaexcel vba picturehow do you concatenate in excelaccess vba forecolorvba macro examplesusing pivot in excelddl and dml commands in sql with exampleshow to combine data from multiple excel filesexcel interactive tutorialexcel mysql connectorexcel vba odbc connectionhow to insert a row above the selected rowvba excel save workbookvb database connection codevba tutorial excelhlookup in excel 2010 with exampleinsert row macro excelvba workbooks.openvba open fileexcel vba cell formattinghow to insert row in excelhow to delete sheets in excelhow to dedupe in excel 2010macro security excelvba if then else examplecell in vbaif cell is not blank excelexcel macro password removerunprotecting an excel worksheetvba processhow to unlock excel workbookfollow hyperlink vba excelvlookup function with exampleshade cells in excelexcel vba procedurevba code to import text file into excelpivot tables in excel 2003delete both duplicates in excelbreak excel password protectioncreate project timeline in excelaccess vba forecolorexcel trend analysis templateexport data from access to excel using vbahow do you remove password protection from excel 2010vba processexcel vba forms advancedvba userform templateshow to add a chart title in excelupdate sql server from excelcreate an excel macroproject estimation excel templateexcel macro to unhide all sheetsvba copy cellsworksheet function in vbarefresh all pivot tables