Hello everyone
I am using the following formula in C1 to get the file name.
=CELL("filename",A1) and I am getting the following result. That is fine
C:\Users\tom\Desktop\list(1)\[list dec 2012.xlsx]CLIST (4)
I need a formula to place in D1 where I should get the result 4.
That is the number appear in the braket. I know, I should use MID and RIGHT and FIND functions. Sometimes it is 2digit number. I am lost when I connect all together.
Can someone fix for me.
Thanks
Bookmarks