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 How To Replace Parts Of String In VBA December 30, 2016 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