Be the first user to complete this post
|
Add to List |
VBA-Excel: String Functions – LTrim()
Description:
The LTrim function removes spaces on the left side of a string.
Format:
Ltrim (strMainString)
Arguments:
- strMainString
- Mandatory
- Type: String
- String whose left space needs to be trimmed.
Function FnLTrim() Dim strMainString strMainString = " Sumit Jain " MsgBox "Before : '" & strMainString & "' and after Left Space is trimmed. After :" & LTrim(strMainString) & "'" End Function
Also Read About Other String() Functions
INSTR() | InstrREV() | LCase()
Also Read:
- VBA-Excel: Create Array using Array() Function
- VBA Excel – Looping Through a Range of Cells
- VBA Excel - Cells, Ranges and Offset : Range
- VBA-Excel: CurrentRegion
- VBA-Excel : Strings Functions – InstrRev