sandiew9560
New Member
- Joined
- Jul 29, 2007
- Messages
- 5
I have a problem that I need to find a formula for. I have a very large spread sheet that has 16000 client names phone # and all info we need.
We are in the process of working with the new VOIP phones. The company handling all the phone programing needs our phone numbers with out the ( ) or -'s I have tried everything to take out that information from each cell with out having to do each one individually. It will take me weeks to take all those out. Is there a formula that will take a number like (888) 321-1234 and make it 8883211234
Please please I need help
Sandie
We are in the process of working with the new VOIP phones. The company handling all the phone programing needs our phone numbers with out the ( ) or -'s I have tried everything to take out that information from each cell with out having to do each one individually. It will take me weeks to take all those out. Is there a formula that will take a number like (888) 321-1234 and make it 8883211234
Please please I need help
Sandie