How to separate part of a existing column into a new column

paulmiddleton

Hello I need to use a right function (like excel) to grab part of an existing column. For example:

Report Title: John Smith Week Ending 01-17-20 I want to grab that date at the end of the Report Title and put in a new column. I can't use substring as depending on the characters in someone's name, the string number of the characters I want could be different. In Excel it would be the right function since the date is always at the end of the report title. Right (A1:8) would give me 01-17-20