This Excel concatenate number and string formula example helps you:
Join a number and a string;
While keeping proper number formatting.
Table of Contents
Excel Concatenate Number and String Formula Template
Excel Concatenate Number and String Example Formula
Excel Concatenate Number and String Explanation
More Excel Training Materials and Resources
Excel Concatenate Number and String Formula Template
For these purposes:
String is the string you concatenate.
Number is the number you concatenate.
NumberFormat is the applicable number format code. You can use the number format code strings from the Number tab of the Format Cells dialog box.
Excel Concatenate Number and String Example Formula
The Excel concatenate number and string example formula below:
Joins:
The string stored in cell B6; and
The number stored in cell B7;
While formatting the number (stored in cell B7) as currency (“$#,##0.00”), with the following characteristics:
Preceded by the Dollar sign ($);
A comma (,) as thousands separator; and
2 decimal places (.00).
The image at the top of this post shows the results I obtain with this Excel concatenate number and string example formula.
Excel Concatenate Number and String Explanation
The ampersand text concatenation operator (&):
Concatenates items; and
Returns a single string with the concatenated items.
Concatenated items (therefore) become strings. In other words: When you concatenate a number and a string:
The number:
Becomes text; and
No longer works as a numeric value.
Excel displays an unformatted (raw) numeric value. For example, “9999.99” instead of $9,999.99)
Use the TEXT function to control how a concatenated number is displayed when creating an Excel concatenate number and string formula. The TEXT function allows you to control how a number is displayed by applying a number format (you specify).
More Excel Training Materials and Resources
You can find more Excel Tutorials (including other formula examples) in the organized Tutorials Archive: Click here to visit the Archives.
If you want to learn more about the basics of working with Excel (including worksheet formulas), you may be interested in the following books (affiliate links):
Excel All-in-One for Dummies: Click here to get this book.
Microsoft Excel 365 Bible: Click here to get this book.
Microsoft Excel Formulas and Functions: Click here to get this book.
The post Excel Concatenate Number and String: Formula Example appeared first on Power Spreadsheets.