I had a customer send me a bunch of phone numbers in word, I copied and pasted them one per line in excel.

Here is the problem (2 parts)

They were sent in the following format

215 555 1212
215 555-1213
Etc..

I need to:
1. Eliminate all the spaces and just have it be one long number
2. I need to add a 1 before the number

The list is about 500 long so doing this manually would take forever... Can someone please help..

TY