Join Text and Referenced Cell
=”TEXT “&TEXT(CELL,”MMMM YYYY”)
Adding Filepath and Filename
=SUBSTITUTE(LEFT(CELL(“filename”),FIND(“]”,CELL(“filename”))-1),”[“,””)
Excel Tip #001
June 30th, 2008 · Comments Off
Tags: Apps
blog.cassandrak.net
This is a blog not of my thoughts, not of my feelings but a blog of what I learn
Categories
Blogroll
Check out these posts that have been featured on Bandelle Blog, a daily source of inspiration, and decor8, your go-to-gal for fresh art and decor.
