Extract every other character from a string
========= QUESTION --------- I have a long number that I need to collect the 2nd, 4th, 6th, and 8th characters from. ========= ANSWER ---------see EXAMPLES ========= EXAMPLES ---------Store: Mid([SurvNum_Span],2,1) & Mid([SurvNum_Span],4,1) & Mid([SurvNum_Span],6,1) & Mid([SurvNum_Span],8,1) ========= APPLIES TO / KEY WORDS ---------Microsoft Access VBA String Manipulation ========= REF --------- http://ycmi.med.yale.edu/nadkarni/access_course/String_Frame.htm [...]