Hello,
I am tryiing to edit prices on a massive spreadsheet and want to know how to
just select numbers out of a cell.
Eg: Cell has "Quantity: 66" and I only want 66
Cell has " Price: $234" and I only want 234
There must be a formula for doing this.
Hope someone knows, as it's doing my head in.
Many thanks.