How to Check First characters Of A String VBA To return the first 3 characters of a string: x = Left(Range(“A1”).Value,3) You Might Also Like VBA 2 Dimensional Arrays January 26, 2018 vba – Object variable or With block variable not set December 23, 2016 VBA – Set Excel Print Settings Fit Sheet on One page January 26, 2018