Historically, the first was an area number, which relates to ... so you can safely remove the hyphens. Use text processing functions to remove the hyphens in Excel and preserve the actual numbers.

The ways to easily remove numbers from the left in Excel are not unique to numbers. You can use this same formula to remove other characters from a string of values in Excel. You can also use the ...

In this post, we will show you how to remove ... text in Excel. You may use this function to remove all the spaces (leading, trailing, and all in-between spaces) from a text string or a number.