I need a formla that could return the values of a name range,

Example name range is "marco" and takes cells A1:A10

A1= 9901 Text
A2= 9902 Text
A3= 9903 Text
..
..
..

I need the formula to return as 9901,9902,9903...

did I make my self clear?