UsefulGyaan Has Posted the Following On 05-10-2013 10:01 PM:

In VBA, LTRIM() function is used to remove the leading spaces from the given string. Syntax: The syntax for LTRIM() function is LTRIM(text) *text is the String that you wish to remove the leading spaces from. Example: Ltrim("***************** UsefulGyaan")********************* ' returns* "UsefulGyaan" Ltrim("**************** UsefulGyaan********* ")************ ' returns* "UsefulGyaan********* " Ltrim("UsefulGyaan********* ")**************************** ' retruns "UsefulGyaan********* " […]





LTRIM() Function VBA: To Remove Spaces