how to select other sounds for my text tone

[tapanass]

I'm sure this has probably been asked already, I'm a noob to the droid. I've tried downloading a couple different apps to help me try to make downloaded tones as my text tone but the apps only alow me to set the tones I have as notifications only. Does anybody know an app that'll help me with this or if I can do it another way. Thank you