Split formula instead of text?

[sss071]

Hi,

I currently have a URL in one cell, with a SPLIT function in another to isolate the Google sheet file ID.

The formula I am currently using is: =INDEX(SPLIT(CELL#, "/"), 1, 5)

However, I would prefer to see a label rather than the long URL. If I use the hyperlink function =HYPERLINK("URL","label") is there any way to still apply the split?
Or I am guessing it might require script instead??

 

[sss071]

Update: I was able to solve this with =INDEX(SPLIT(FORMULATEXT(CELL), "/"), 1, 5)