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 and I need to only extract the number.
How is this done ?
Appreciate your help
Thanks
3 Replies
lion555 Let's say the text string is in A1, use this to extract only the numbers.
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
Simply create helper column with flash-fill function to extract only numbers.
https://support.microsoft.com/en-us/office/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7#:~:text=You%20can%20go%20to%20Data,the%20Automatically%20Flash%20Fill%20box.
thanks
