How to use String Functions (Left, Right and Mid) in Excel VBA

How to use String Functions (Left, Right and Mid) in Excel VBA