Transformer
05-17-2013, 12:32 AM
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********* " […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=665&subd=usefulgyaan&ref=&feed=1
LTRIM() Function VBA: To Remove Spaces (http://usefulgyaan.wordpress.com/2013/05/10/ltrim-function-vba/)
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********* " […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=665&subd=usefulgyaan&ref=&feed=1
LTRIM() Function VBA: To Remove Spaces (http://usefulgyaan.wordpress.com/2013/05/10/ltrim-function-vba/)