Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Perform case-sensitive Lookup in Excel
  • Last row number in range
  • How to use Excel LOOKUP Function
  • How to get first row number in range in Excel
  • How to retrieve first match between two ranges in Excel

Data Analysis Examples

  • Subtotal function in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How to Create Area Chart in Excel
  • How to count table rows in Excel
  • How to perform a t-Test in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation must contain specific text
  • Excel Data validation only dates between
  • Excel Data validation number multiple 100
  • Excel Data validation unique values only

Tag: CONCATENATE function

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

by

What is CONCATENATE function in Excel? CONCATENATE function is one of TEXT functions in Microsoft Excel that is used to join two or more text strings into one string. Syntax: CONCATENATE(text1, [text2], …)For example: =CONCATENATE(“Stream population for “, A2, ” “, A3, ” is “, A4, “/mile.”) =CONCATENATE(B2, ” “,C2) Important: In Excel 2016, Excel Mobile, and Excel …

Continue Reading

Join first and last name — Manipulating NAMES in Excel

by

If you need to join separate first and last names together into a single full name, you can easily do so with concatenation using the ampersand (&) character. In the formula below, first is first name, and last is last name. Formula =first&” “&last Explanation In the example, the active cell contains this formula: =B4&” “&C4 How this formula …

Continue Reading

Join Text Strings Using Concatenate or ‘& Operator’ in Excel

by

This example illustrates how to concatenate (join) strings in Excel. When joining text and a number, use the TEXT function to format that number. 1. Simply use the & operator to join strings. Note: to insert a space, use ” ” 2. The CONCATENATE function produces the exact same result. 3a. The CONCAT function in Excel 2016 produces the exact …

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
  • How to abbreviate names or words in Excel
  • How to extract name from email address in Excel
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • Extract last name from full name — Manipulating NAMES in Excel
  • Get first name from full name — Manipulating NAMES in Excel
  • Series of dates by day
  • Calculate expiration date in Excel
  • Get work hours between dates and times in Excel
  • Get project midpoint in Excel
  • SECOND function: Description, Usage, Syntax, Examples and Explanation
  • Calculate periods for annuity in Excel
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • SLN function: Description, Usage, Syntax, Examples and Explanation
  • NPER function: Description, Usage, Syntax, Examples and Explanation
  • FVSCHEDULE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles