4.79/3.94
Is there a way to make a formula in another cell based on this entry?
I don't want to enter it as math in this cell.
In this case. 4.79-3.94.
Left of / minus Right of /.
Mac mini, macOS 12.7
If 4.79/3.94 is text in cell B2,
=TEXTBEFORE(B2,"/")−TEXTAFTER(B2,"/")
Figured it out.
() around the TEXTBEFORE - TEXTAFTER.
Thanks badunit
I don't know what you are doing where copy/pasting the formula would copy/paste the source (the "4.79/3.94" from the cell being referenced in the formula). And the only way I can think of that would paste the results of the formula and not the formula itself would be if you used Paste Formula Results.
If you want the formula in the rows below and want them to reference the text from those rows, select the cell that has the formula then drag down on the little yellow dot that appears when you hover the mouse over the bottom line of the selection box. Hopefully that makes sense when you see it. Or you can select the cell (single click on it), copy, then paste to the other cells. The cell references in the formula will change to match the new rows/locations.
did both methods you wrote in the 2nd paragraph with a number of other "textless" formulas on the sheet with no issue.
but with the textbefore/after, no joy.
and def didn't Paste Formula Results at all. But the textbefore/after is small math I can do in my head, so not as big a deal as other multi-cell formulas I'm using successfully.
I wack at it some more
thanks.
is what I entered into M4.
yields a syntax error. what am I missing?
Judging by what you posted, you have two too many "(". When you have it correct it will look like this:
ah ha, so the app inserts the () in writing the formula, which is I guess what them half moons are.
Thanks, I'll try again.
no syntax error, but wrong result.
can't copy & paste formula. it pastes in the result of the source without the formula
Numbers left/right cell formula
