search and replace on blank removing leading 0's

I've a column of data in excel which should represent telephone numbers -for some reason the data input technician has added random spaces between 'segments' of the number. Currently that column is formatted as text for whatever reason. If I search and replace to replace a space with no space, it deletes all the numbers leading 0 therefore destroying the data. Is there anyway past this, to remove the leading, mid section or trailing spaces, but the process not deleting the leading 0's which is how the vast majority of numbers are?
Who is Participating?
NorieVBA ExpertCommented:
You could use the SUBSTITUTE formula.

=SUBSTITUTE(A2, " ", "")

That will remove all the spaces and keep the leading zeroes.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.