I have a question that I have not seen answered.

[tuaca12000]

Can someone please point me to a forum that addresses this or if there is none, can someone please answer this question. I have a report that is sent to us as a .txt file that we then go in and copy to an Excel Spreadsheet. We then separate the columns using the Text to Columns feature. The question I have is that one of those columns contains a list of phone numbers in the following format (###)###-####. I need to see if it is possible to take that column and reformat it so that the parenthesis and the hyphen are no no longer in the string of numbers so that I just have the 10 digit number formatted like this: ##########. Please help. The only way I have been able to do this is to separate the phone numbers using the Text to Columns feature and place separators between the parenthesis and the numbers, and between the hyphen and the numbers, then go in and delete the columns that contain the parenthesis and the hyphen. However, that creates three distinct columns. I need a way for all 10 digits to be in one cell so that I can then copy and paste those numbers into another system.