I have an 11 digit code called photo_code. 10401610016

I want to split it up into two variables called code1 and code2

code1 should be the first 6 digits of photo_code
code2 should be the last 5 digits of photo_code

I know that this can be done with a couple of simple TRIM statements but I cannot seem to figure out how to make this work with variables.

Thanks.

code1 = Left(photo_code, 6)
code2 = Right(photo_code, 5)

Thanks! I had the order wrong!