Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings I have USA / 0002 in column H starting in row 5. The only thing I want up & down the Column is the first three letters. In the example I want to be left with USA. The there are nearly 300 different letter codes.
The code I'm wanting to use is, but I'm off the mark: Thank you!
The code I'm wanting to use is, but I'm off the mark: Thank you!
VBA Code:
Sub UseLeft()
Dim LResult As String
With Range("H5", Range("H" & Rows.Count).End(xlUp))
LResult = Left(text, 3)
End With
End Sub