Format Excel Phone Number i need no spaces?

Question

i have phone numbers [phone] i need them to be like this 0000000000 i have excel 2007 thank you

Answer 1

Supposing your phone numbers are in column A (starting in A1), then in cell B1, type the following exactly:



=mid(A1,2,3) & mid(A1,7,3) & right(A1,4)



Copy/paste this formula as needed in column B and you should be set.

Answer 2

Format Cells Custom, and just type 0000000000 and click OK

Try What Wesley suggest, and in order to not to have data in two different places, copy the range where the Mid function is and then do a paste special values where the data originally is, then delete the range where the Mid Function is.

Answer 3

If you're importing text with formatting and you want to remove the formatting, you can use a VERY messy formula, or you can write very simple VBA code to do it.