Attempting to use the right() string function to remove the front end text from the data in a field. The data is represented as "SRF-123456" with unique values for each entry. I want the column to only display the numbers. I have not had any success using the right() formula. Any help would be appreciated.

Thanks, Brent