Adding Symbols to Numbers in Excel

Using CHAR Formula

To add a symbol after a number, use the CHAR formula in Excel. This function displays symbols based on specific codes. To append a special symbol to a number, include the CHAR formula with the appropriate symbol code.

Applying Custom Format Tool

Older Excel versions can utilize the custom format tool to add symbols after numbers. Create a custom number format by clicking "Number Format" on the Home tab, selecting "More Number Formats," and choosing "Custom" from the Category box. Use up to four sections of format code for different number types, separated by semicolons.

Combining Text and Numbers with CONCATENATE

The CONCATENATE function in Excel combines text and numbers, including symbols. However, it's recommended to use the CONCAT function instead, as CONCATENATE may not be available in future Excel versions.

Utilizing TEXTJOIN Function

TEXTJOIN can also combine multiple ranges and strings, including symbols with numbers. Note that TEXTJOIN is not available in Excel 2013 and earlier versions.

Using Ampersand Operator

The ampersand (&) operator is a simple way to combine text and numbers in Excel. Place an ampersand between a number and a symbol enclosed in quotation marks to concatenate them.

Formatting Numbers with Symbols

Excel's number formats allow users to change the appearance of numbers by adding symbols without altering the actual number. Built-in number formats can be used as is or as the basis for custom formats. Excel for Microsoft 365 for Mac, Excel 2021 for Mac, and Excel 2019 for Mac all support these formatting options.

Common Use Cases

• 
  Displaying currency values with their appropriate symbols
• 
  Appending units of measurement to numerical data
• 
  Indicating temperature scales, such as Celsius or Fahrenheit, after numbers
• 
  Adding percentage signs to numbers to represent percentages
• 
  Marking numerical data with custom symbols for specific categorization or notation

Excel vs. Sourcetable: A Comparative Overview

Microsoft Excel and Sourcetable serve as powerful tools for data management and analysis. Excel, a well-established program, is known for its versatility in data manipulation. Sourcetable, entering the market, specializes in aggregating data from multiple sources into one intuitive interface.

Excel's prowess lies in its comprehensive features and widespread adoption. However, Sourcetable's innovative AI copilot enhances the user experience by assisting in formula creation and providing templates through a conversational interface.

While Excel demands a certain level of expertise for advanced functions, Sourcetable democratizes data analysis by simplifying complex tasks. Its AI-driven guidance is designed to streamline workflow and improve efficiency for users of all skill levels.

The choice between Excel and Sourcetable hinges on the user's needs. For traditional spreadsheet tasks, Excel remains a robust option. For those seeking a seamless integration of diverse data sources with AI-powered assistance, Sourcetable emerges as a compelling alternative.