I have a column of numbers, but each contains a colon at the end (e.g. "1223:").. I'd like to have excel treat each one as a number. Is there a way to have excel automatically remove the colon and space at the end of each number?

Search and replace does not seem to work, since it doesn't seem to "find" the colons.

Thanks!