Hyperlink to specific text in another worksheet (II)

hey guys, i got this formula from another thread in this forum:
http://www.excelforum.com/excel-work...worksheet.html

Let's say if there's a text in A1 & this formula in B1:
=HYPERLINK(CELL("address",INDIRECT("Sheet2!A"&MATCH(A1,Sheet2!A:A,1))),A1)

This formula/hyperlink will link it to Sheet2 & find the text.

But when i tried to name my file with spaces, it does not work anymore.

Attached "Book5" that works (No spaces in filename) & "Book 5" that does not work (a space in filename)

When you reference a file with a space in windows you have to use quotes around the link. So the middle bit produces '[Book 5.xls]Sheet2'!$A$5. It needs to have ["Book 5.xls"]Sheet2'!$A$5.

I can't figure a way around it. It seems to be a bug maybe you can try using =address() and match()

hey darknation144, yeah i did realise that difference too. didnt know how to resolve it. thanks anyway

i've found a solution, if anybody's interested:
=)
=HYPERLINK(MID(CELL("filename",Sheet2!$A$1),FIND("[",CELL("filename",Sheet2!$A$1)),256)&"!"&ADDRESS(MATCH(A1,Sheet2!A:A,0),1),Sheet1!A1)