Numbers in Text

[wcdonkinmecom]

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 ?

[#2]

@wcdonkinmecom depends if the number of text values or numbers change.

you can use functions like left() and right()