=Format(string format, {object arguments}) : string    

Results from function inside Excel


Concatenates a string by inserting the value of one or more cells at specific locations in the string.

This function is based on the .Net String.Format Method.

You can supply Format with multiple vectors:
Example of how to use multiple vectors

Note that Date formatting doesn’t work because Excel treats dates as numbers.


Format is really useful for building SQL statements:

SQL Statements Example

Fully supports .Net composite formatting (string.Format).

=Format("{0:0.00}",123.4567) => "123.46"
=Format("{0:0000}",3) => "0003"


Official Documentation

Get help with this function in the community →