Not sure what you need
=A1&","&A2&","&A3&","&A4&","&A5&","&A6&","&A7&","& A8&","&A9&","&A10

"MESTRELLA29" wrote:

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?