Number and Text in same cell but need the cell to read as a number

nicole5462   To add to what Sergei already said, the best long term solution to your problem is to re-design your spreadsheet so that you don't have the problem in the first place. Unless, as he said, there's a known and very regular pattern (e.g., digits are always limited to four, text to two characters)... unless there's some regular pattern like that, you will always be faced with the challenge of parsing out what should have been two separate fields or cells in the first place. It's one thing to have a part number that combines arabic numerals with text; quite another to have a cell with, say, numbers ordered and city abbreviation (if that's what "sf" is in your example)....