Excel @right function

New 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

 

Thanks

 

 

 

3 Replies

@lion555 

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

Using Flash Fill in Excel (microsoft.com)

thanks

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

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

@sivakumarrj 

 

Thank you