Take an example of Left and Left$:
Dollar sign functions return a value of type String. The
non-dollar sign functions return a Variant Data Type.
Dollar sign functions run faster than non dollar sign functions, so in general, it's a good choice to use them.
Do you need the non-dollar sign function?
Yes---if there's a possibility that the function will encounter a Null character in its argument string, you
need to use the non-dollar sign version--otherwise the function will bomb.
For instance, in this code:
Left(string1, 1)
Left$(string1, 1)
both will return the left-most character of the string. However, if string1 contains a Null
character, Left$ will bomb---however, Left will work fine.
Sharing the best from my side...
--Prashant--