In a doc library, the Title column is blank but the Name column contains the filename of the document uploaded. I want to concatenate (?) the Title column to auto fill-in what the Name column contains. Is there a simple calculated formula to use? My point in doing this is to create a lookup column from a List to include the name(s) of the documents in a Doc Library, yet the only seemingly relevant columns I can "lookup" are the Title column, which is not blank in that Doc Lib list.
Thanks for any assistance!