Extracting Data from a Cell with Standard Naming Convention

Ok guys this is a tricky one...

I have a set of data with a column of "names" that have certain substrings of information separated by underscores (_).

e.g. sampledata1_moredata2_moredata_moredata3_moredata4_moredata5

I would like to write a function that says "pull data after 2nd underscore third underscore and fourth underscore, leaving out everything else" or "pull data from after the 4th _ and after the 5th _" you get it....

I wrote a similar code in SQL the other day that worked well if any of you guys use both programs I'll add it (below) for reference.

 select
                substring ([creative name], charindex ('_', [creative name])+1, 
                charindex ('_', [creative name], charindex ('_', [creative name])+1)-charindex ('_', [creative name])-1)
as [creative name_2],

For reasons not worth explaining I need to recreate this in excel... any thoughts?