trim or trim$ what is the difference

  • Thread starter Thread starter Guest
  • Start date Start date
Trim() accepts and returns a Variant.

Trim$() accepts and returns a String.

As an example, a string type cannot be Null, so you receive an error if you
use:
Trim$(Null)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trimming leading spaces from fields 4
Sony Vegas Pro - Trimming screen pixels? 1
Outlook help regarding outlook vba 0
Trim statement with an array 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
trim function 2
Filter only returning 1 record 2
Huge Video File After Edit 3

Back
Top