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

Data Analysis

  • How to create dynamic reference table name in Excel
  • Add Outline to Data in Excel
  • How To Insert and Customize Sparklines in Excel
  • Excel Bar Chart
  • Conditional Formatting New Rule with Formulas in Excel

References

  • How to use Excel OFFSET function
  • How to get address of last cell in range in Excel
  • How to get relative column numbers in a range in Excel
  • Last row number in range
  • INDEX function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation must contain specific text
  • Excel Data validation specific characters only
  • Excel Data validation unique values only
  • Excel Data validation require unique number
  • Excel Data validation number multiple 100

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

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

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

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

  • IF with wildcards in Excel
  • Return blank if in Excel
  • How to use Excel AND Function
  • How to use Excel NOT Function
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • Steps to create Dynamic calendar grid in Excel
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Convert decimal hours to Excel time
  • How to calculate next day of week in Excel
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • If cell contains one of many things in Excel
  • Categorize text with keywords in Excel
  • Group numbers with VLOOKUP in Excel
  • Map text to numbers in Excel
  • Map inputs to arbitrary values in Excel

General

  • Subtotal by invoice number in Excel
  • Currency vs Accounting Format in Excel
  • Convert column number to letter in Excel
  • 231 Keyboard Shortcut Keys In Excel
  • Sum by group in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning