This feature is free. Check out the awesome benefits of becoming a Pro User.

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


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:

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


Format is really useful for building SQL statements:

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 →