Formula to Extract site code from text string

[bbeards]

Hi, I need help creating a formula that will extract a site code from text strings with varying lengths. For example this is the text string and I want to extract the red text into a new field.
HONEG BUCKETFLOHAWK//PUYALLUP//98373//103137391INACT//US

I have attached a sample of my data.

Thank you for your help.

[Glenn Kennedy]

Hi there. This should do th ejob for you:

=TRIM(MID(SUBSTITUTE("//"&$A2,"//",REPT(" ",100)),400,100))

[Glenn Kennedy]

I don't know what you changed in your first post AFTER I replied to you. Please don't post-edit posts, as it can cause confusion! It seems, however, that you got sorted. If so, you're welcome. That said, some feedback is always appreciated!!

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.