hey i figured out why it wasnt working properly. the data that my range referenced initially had "@ " and I used right/len-1 to get rid of it instead of right/len-2. there was a blank in front of the data that i could not see because of that slight mishap! thanks for your help though.