Excel @right function

Copper Contributor

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 and I need to only extract the number.


How is this done ?



Appreciate your help






3 Replies


Simply create helper column with flash-fill function to extract only numbers.

Using Flash Fill in Excel (microsoft.com)


@lion555 Let's say the text string is in A1, use this to extract only the numbers.

=RIGHT(A1,LEN(A1)-FIND(" ",A1))



Thank you