Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel template with filepath as footer
Is there any way I can create an Excel Template with the page set-up footer to contain the file path and name. I can only see how to get it to include the file name and not the path as well. We work in a team and people often forget to put the file paths in the footers. If I can create a...- ijes
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Splitting data from one cell into three cells
I wish to split the contents of one cell into 3 cells as follows; Cell A1 contains (15 digits) I wish to put the first 7 digits into B1 =left(a1,7) last 3 digits in D1 =right(A1,3) how do I put digits 8 to 12 (5 digits) into cell C1? I know I could put the contents of A1 less the last three...- ijes
- Thread
- Replies: 3
- Forum: Microsoft: Office
