This version adds in three new macros – LEFT, RIGHT and MID
LEFT
Replaces the value with the left x characters of the value
LEFT(VALUE,COUNT)
e.g. LEFT(4.0m: Moderate,4) will output 4.0m
RIGHT
Replaces the value with the right x characters of the value
RIGHT(VALUE,COUNT)
e.g. RIGHT(4.0m: Moderate,4) will output “rate”
MID
Extracts a substring of length COUNT characters from this value, starting at position FROM
MID(VALUE, FROM,COUNT)
e.g. MID(4.0m: Moderate,7,3) will output “Mod”
You can also omit the COUNT value to get the remainder of the value
e.g. MID(4.0m: Moderate,7) will output “Moderate”