Category Archives for "How To…"

How to get filename in Excel

  As a follow on from the last post, I was asked how to get filename in Excel using similar formulas. This can be done with the formula below. =MID(CELL(“filename”),(SEARCH(“[“,CELL(“filename”))+1),(SEARCH(“]”,CELL(“filename”))-6-(SEARCH(“[“,CELL(“filename”))))) Really simple isn’t it?  I bet you were wondering how you didn’t figure it out yourself!! This combines 3 formulas, MID, CELL, and SEARCH. I’ll […]

Continue reading

Get every new post delivered to your Inbox

Join other followers: