Aug 05 2020 05:43 AM
Hi All
I would like to reference a cell which contains a number in some text in a seperate cell. For example, in one cell is an invoice number which gets changed and I would like it to change in the text line in a cell lower which might say" Please use the reference number of "the invoice number from the changed cell" when making a deposit. Can anyone help ?
Aug 05 2020 06:49 AM
@wcdonkinmecom depends if the number of text values or numbers change.
you can use functions like left() and right()