Dec 07 2019 12:04 PM
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
Dec 07 2019 12:11 PM
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.
Dec 08 2019 10:13 AM
@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)....