Forum Discussion
Excel @right function
I am trying to extract numbers after the check and space in excel column so I can do a vlook up against the number from another spreadsheet. For example I have a column that lists CHECK 668911192 an...
lion555 Let's say the text string is in A1, use this to extract only the numbers.
=RIGHT(A1,LEN(A1)-FIND(" ",A1))