-
How do I split up a string into 3 sections i.e. I have a text box ( TextF ) which consists of four numbers then four letters then four numbers. How can I make it so that the first set of numbers is put in one textbox ( Text1 ), and the set of letters is put in another textbox ( Text2 ) and finally the last set of numbers are put in another textbox ( Text3 ).
This shows the start and result I am after.
Code:
TextF = 9583ABNF3746
'<<<<<<<code I need>>>>>>>>
'this is the result I need...
Text1 = 9583
Text2 = ABNF
Text3 = 3746
can anyone help??
-
<?>
Text1=left(TextF,4)
Text2=Mid(Textf,5,4)
Text3 = Right(TextF(4)
-