SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If I have a docuent library that has a documents in it using the following format: Region_Division_Store.pdf ...notice the underscores.

I also have three columns named Region, Division, Store. These columns are calculated based on the Title Column.

The documents will be added via the email to list capability.

How can i go about setting the column texts by seperating the string at the underscore.

at this time i am able to get the index of the first underscore using =SEARCH("_",Title,1), but this only gives me the index of the first underscore

Any and all help will definitley be appreciated

share|improve this question

Assuming your Title field has Region_Division_Store format, here is how it can be done.

Region -- =LEFT(Title,FIND("_",Title)-1)




share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.