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...
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
