Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Thermometer Chart in Excel
  • How to Sort by Color in Excel
  • How to Use Solver Tool in Excel
  • Everything about Charts in Excel
  • Chart Axes in Excel

References

  • Lookup entire row in Excel
  • Two-way lookup with VLOOKUP in Excel
  • How to get last column number in range in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel ROW Function

Data Validations

  • Excel Data validation with conditional list
  • Excel Data validation require unique number
  • Excel Data validation exists in list
  • Excel Data validation must contain specific text
  • How To Create Drop-down List in Excel

Tag: CODE function

CODE function: Description, Usage, Syntax, Examples and Explanation

by

What is CODE function in Excel? CODE function is one of TEXT functions in Microsoft Excel that returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer. Operating environment Character set Macintosh Macintosh character set Windows ANSI Syntax of CODE function CODE(text) …

Continue Reading

Remove unwanted characters in Excel

by

To remove specific unwanted characters in Excel, you can use a formula based on the SUBSTITUTE function. Formula =SUBSTITUTE(B4,CHAR(code),””) Explanation In the example shown, the formula in C4 is: =SUBSTITUTE(B4,CHAR(202),””) Which removes a series of 4 invisible characters at the start of each cell in column B. How this formula works The SUBSTITUTE function can …

Continue Reading

How to abbreviate names or words in Excel

by

To abbreviate text that contains capital letters, you can try this array formula based on the TEXTJOIN function, which is new in Excel 2016. You can use this approach to create initials from names, or to create acronyms. Only capital letters will survive this formula, so the source text must include capitalized words. You can …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel

Date Time

  • Find Last Day of the Month in Excel
  • Convert text to date in Excel
  • Calculate time difference in hours as decimal value in Excel
  • How to calculate Quarter of Date in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Running count group by n size in Excel
  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel

General

  • How to calculate percent sold in Excel
  • Check if range contains a value not in another range in Excel
  • How to add sequential row numbers to a set of data in Excel
  • How to calculate project complete percentage in Excel
  • Excel Default Templates
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning