Excel @right function

[lion555]

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

Thanks

[#2]

@lion555 

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

Using Flash Fill in Excel (microsoft.com)

thanks

[#3]

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

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

[#4]

@sivakumarrj 

Thank you