I have a document library in which are a couple thousand image files formatted as such:
CQYr UnqID Title FNme LNme Agency
2020 RR0000 Bus Driver Roger Rabbit Federal
I am trying to create several calculated columns in the SP library for filtering purposes. Yep, I've been told that I may not be able to filter using calculated columns; my focus is on the calculation at this point; why is it not working?.
My first attempt was to extract the CQYr from the Title using the following. The result in the calculated column is #Name?.
Any thoughts?
=LEFT(Title,(FIND(" ",Title)-1))