Skip to content
SOPHUC

Excel is easy to learn

Menu
  • Home
  • Tips
  • Excel functions
  • text strings
  • Date function
  • Database functions

Category: text strings

A text string, also known as a string or simply as text, is a group of characters that are used as data in a spreadsheet program. Text strings are most often comprised of words, but may also include letters, numbers, special characters, the dash symbol, or the number sign. By default, text strings are left-aligned in a cell while number data is aligned to the right.

How to use DBCS Function in Excel
text strings

How to use DBCS Function in Excel

ExcelAugust 10, 2020June 15, 20200
DBCS function in excel is a text/string function. Its full form is (Double Byte Character Set). This function is used …
Read More
How to use CONCAT Function in Excel
text strings

How to use CONCAT Function in Excel

ExcelAugust 9, 2020June 14, 20200
The Excel CONCAT function concatenates (joins) values supplied as references or constants. Unlike the CONCATENATE function (which CONCAT replaces), CONCAT …
Read More
How to use UNICODE Function in Excel
text strings

How to use UNICODE Function in Excel

ExcelJune 14, 2020June 14, 20200
The Excel UNICODE function returns a number (code point) corresponding to a Unicode character in decimal format. Unicode is computing …
Read More
How to use TEXTJOIN Function in Excel
text strings

How to use TEXTJOIN Function in Excel

ExcelJune 14, 2020June 14, 20200
The Excel TEXTJOIN function concatenates (joins) values with a given delimiter. Unlike the CONCAT function, TEXTJOIN allows you to supply …
Read More
How to use UNICHAR Function in Excel
text strings

How to use UNICHAR Function in Excel

ExcelJune 14, 2020June 14, 20200
The Excel UNICHAR function returns a Unicode character based on a given number. Syntax:= UNICHAR (number) The UNICHAR function syntax …
Read More
How to use the Excel T function
text strings

How to use the Excel T function

ExcelApril 13, 2020April 14, 20200
The Excel T function returns text when given a text value and an empty string (“”) for numbers, dates, and …
Read More
How to use the Excel VALUE function
Excel functions

How to use the Excel VALUE function

ExcelApril 13, 2020April 14, 20200
Value function in Excel gives the value of a text which represents a number for example if we have a …
Read More
How to use the Excel UPPER function
text strings

How to use the Excel UPPER function

ExcelApril 13, 2020April 14, 20200
The UPPER function is an Excel Text function, that will convert text to all capital letters (UPPERCASE). Thus, the function …
Read More
How to use the Excel TRIM function
Excel functions

How to use the Excel TRIM function

ExcelApril 13, 2020April 14, 20200
Trim function in excel as the name suggests itself it trims some part of any string, why string because it …
Read More
How to use the Excel SUBSTITUTE function
text strings

How to use the Excel SUBSTITUTE function

ExcelApril 13, 2020April 18, 20200
Substitute function in excel is a very useful function which is used to replace or substitute a given text with …
Read More

Posts navigation

1 2 3 Next ›
Search for

Popular Posts

    Recent Posts

    • How to use VAR.S Function in Excel
    • 10 Ways to Raise Your Excel PivotTable Game
    • What are PivotTables in Excel? What Can You Do with Them?
    • 4 Reasons for Marketers to Love Pivot Tables [Excel Tricks]
    • SUBTOTAL in Excel: Everything You Should Know

    Recent Comments

      Categories

      • Average
      • Compatibility functions
      • Count
      • Cube funcitons
      • Database functions
      • Date function
      • Engineering functions
      • Excel
      • Excel functions
      • excel min max
      • Financial functions
      • Information function
      • Logic function
      • Lookup and reference
      • Math and trigonometry
      • Power BI
      • Statistical functions
      • sum
      • text strings
      • Tips
      • Vlookup excel

      Sitemap

      1. Post
      2. Page
      3. category
      4. Post_tag
      5. Author
      Proudly powered by WordPress
      RedWaves theme by Themient
      Menu
      Search for
      • Home
      • Tips
      • Excel functions
      • text strings
      • Date function
      • Database functions