Converting columns to Text format....

[JasonLeisemann]

I have a spreadsheet I'm working on that's supposed to convert a long list of values into data for an uploader.

In the end product, I not only need the various rows that I'm adding, but I need it in Text format. I know that I can adjust the formatting through the following:

Please Login or Register  to view this content.

But I'm not sure what goes in for the ?. Any help? "A-Z" maybe?

[Cofad]

I used the macro record to figure what the syntax is. When I selected a column and changed the format to text I got the following:

Please Login or Register  to view this content.

Hope this help!

[JasonLeisemann]

Thanks! Minor tweak to the start product from what was provided, and it worked perfectly.

[Cofad]

Glad to help.