When including numeric values in the expression to build up a character string, it’s common to use the Trim (removes leading and trailing spaces) and Str (converts numerics to characters) functions together, such as: Trim(Str(MyValue))
The equivalent when programming in Excel is the Cstr() function, so why not go ahead and build yourself a custom function […]

continue reading.....