I’m doing this, but it doesn’t work:
=&ROW(D(RIGHT(A21, LEN(A21)-SEARCH(" ", A21, 1))))
I want to calculate the find number from a different cell, and append it to
Drow to get for example:
You can accomplish this one of two ways. Take a look at the function
The "ref_text" can be text that refers to a cell. For example if I put:
where "A1" is text, I can reference a cell. You can piece together the text in this function using other formulas like yours in the original post.
Another way that may work for you as well is to use the function
=OFFSET(reference, rows, cols, [height], [width])
to which you reference a cell initially and then tell the function how many rows or columns you are away from that cell.