Thank you, that did the trick. I have a second question now.

I have my new column of text data that works great. In a separate sheet I have to reference these text numbers in the "text" format. When I type "=A1" into a cell formatted as text I get the exact output =A1 displayed. Not the formula. That exact text string =A1. Of course that is to be expected. How do I get around this?