Quote:
Originally Posted by hbcobra
Here is a link to a sample .xlsx I am using on Dropbox:
http://dl.dropbox.com/u/1185462/Sample.xlsx
Currently I am copying the data in column B and pasting it as a value into column A. It would be great if I could use a formula to get a static text value in column A since my original column E values are going to change quite often.
In addition, is there a way to trim the "CAL" and the ".PDF" in a single formula? Currently I have it as two separate formulas (columns C and D).
Thank you very much. |
Enter
=MID(E2,4,6) in C2 of your example and copy down. You then don't need column D so it can be deleted. That's your second query dealt with.
I'm still not sure I get what you mean for the first one though. Why do you need to convert the dates to a static value?
Similar Threads
Threaded Mode
