Forum Discussion
Number and Text in same cell but need the cell to read as a number
How can a cell be "read" as a number for formuals but have text after it. ie. 1,234 sf but need to use the number for a formula in another cell
It depends on how number & text appeared in first cell. For example, you may apply custom format to the cell with 1234 as #,###" sf" and it will be shown as 1,234 sf.
If there is some logic in how and text placed (e.g. number is before first space) it could be extracted by formula.
If no logic - perhaps it's possible to extract digits one by one, but it'll be bit complicated.