Easy Question!

[ttsteve121]

I have a cell that was originally saved as text 111-11-11. I want to get the format to be 1111111 so that I can sort it with another list of the format 11111111. Any suggestions?

 

[shg]

Select the column of interest, do Ctrl+H (Find and Replace), put a hyphen in the Find box, leave the Replace box empty, press Replace All.

 

[ttsteve121]

bingo