Return Certain Text Randomly Located in a Cell

Good Afternoon,

I'm putting together a spreadsheet to help me organize which disciplin incoming files belong to. The way I have it set up is as follows:

Column A has the file name
Column B is where I want the specified text to go
Column C and D are just general information
Columns E-N are the different disciplins

So, an example of how the files are named:
BT3.BW 1.0
CH.EL 1.0
BT54.PL.1.0
CH.PL.1.0

The text between the two periods is the text im interested in. That denotes the disciplin the file is associated with. So for the first file I would want the cell to return "BW". I would use the =Right or =Left and then specify a number of characters, however in this case the number of characters is different depending on the file type.

Once I have the value between the two periods I can link that back to a table on another sheet and use VLOOKUP to to properly soort them.

Any ideas on how I can do this?

Thanks in advance!

Hi -

The attached uses a helper column, but it returns all text between the "." delimiters.

Hope this helps.

After re-reading your post, I think Harribone's solution best meets you needs.

Works Great! Thanks for the help!