how to truncate blanks from data in excel. 1

[wvdba]

Hi.
i have an excel file that contains first_name, last_name and middle_names.
when i received the file, i ran it against a database for matches, and found out that there were no matches. we know for sure that those names are in the database. after displaying the sql statement, we found out that the names are padded with blanks to be 20 chars long.
is there any way to truncate the padded blanks and then run the data in the vb script?
thanks.

 

[PHV]

Have a look at the Trim function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[wvdba]

thanks, PHV.
i'll take a look.

 

[wvdba]

thanks PHV.
it worked perfectly.
cheers.