Text

Excel Text Functions:

Explained with Examples.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

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.
LIMITED TIME OFFER

Related pages


tick on excel spreadsheetconverting excel to csvrange property vbams excel vlookup functionconcatenate in excel 2010meeting agenda word templatesql quiz questions and answers pdfadodb.connectionvlookup range lookupsample excel vba projectswhat is the vlookup function in excelwizard excelestimation templatesgantt project planner excelexcel formulas offsetexcel reports and dashboardsvba convert to integerhow to combine multiple excel sheets into one sheetmerge cells exceldata analyst interview questions and answers pdfadvanced filter macroproject log template excelexcel unlock workbookunlock vba codeexcel if statements examplesexcel formulas color codinghlookup excel 2013microsoft excel dashboard templatesdashboard examples pptascending order worksheetautomatic hyperlink excelhow do you count rows in excelhow to delete activexis there a way to find duplicates in excelexcel rngexcel vba clearcontentsvba application.enableeventsinserting columns in excelcreating a simple macro in excel 2010data type in vbavba name rangemicros and macros in excelfence estimate templatevb source code exampleswhat is ddl and dmlfind duplicates in excel 2003excel record a macrovba forms examplesdelete column vbaprint vba codevba excel queryproject gantt chart template excelms access trim functionvba for ms accessms excel timeline templatevba sumifs functionvisual basic commands excelhow to use hlookup functionhow to put countif formula in excelvlookup explained simplypowerpoint dashboard templateexcel sort ascendingenable developer in excelfunctions in vba excelcreate pivot table in excel 2007excel formula is not blankinsert rows in excel shortcutobjfso.opentextfiledashboard template excelvbscript msgbox examplessql identify duplicates3d pie chart excelaverageifs excel 2010excel formula to count duplicates