Get Digital Help
  • Home
  • Templates
  • Products
  • Functions
  • Archive
  • Contact
  • About Me
    • About me
    • Blogs I read
    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


Archive for TRIM function


Extract k-th word in cell value

The formula displayed above in cell range D3:D9 extracts a word based its position in a cell value. For example, […]

How to use the TRIM function

The picture above shows you values that have multiple leading and trailing blanks, sometimes also between words. The TRIM function […]

Extract last word in cell

The formula demonstrated above in cell range C3:C9 extracts the last word from adjacent cell in column B. =TRIM(RIGHT(SUBSTITUTE(B3, " […]

Text to columns: Split words in a cell [Array formula]

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

      Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
  • Welcome! I am Oscar and here to help you!

    Feel free to comment and ask Excel questions.

    Don´t forget to add my RSS feed and subscribe to new blog articles by email.

  • Free Blog Emails

     

  • Search website