I have a document library with a 'Name' column that has files formatted as follows:
CQYR UnqID Title FirstName LastName
2020 RD0000 Teacher Rodger Dodger
Is it possible to add/create a calculated column that includes only a portion of the 'Name'?
Say, I want to filter these images by Title (or Last Name, or UnqID), in the 'Name' column, can a formula be written into a calculated column that automatically extracts only the text I need and then use it to filter the images?