Different formats for different string values (Format function)

Different formats for different string values (Format function)

See Also        

A format expression for strings can have one section, or two sections separated by a semicolon.

If you use The result is
One section only The format applies to all string data.
Two sections The first section applies to string data, the second to Null values and zero-length strings ("").