What is the data type of your range? if it is not text, you may need to convert it to text first.

Is it a single cell range?