Using formula to convert date result to text

[hbcobra]

Hello,

I used a formula to convert text into a specific date value. Now
would like a formula to convert that result into text. I understan
that you can do a past special and only paste the values, but I a
wondering if there is a formula to do this so I do not have t
constantly re-copy and re-paste when I make changes to the original tex
strings.

Thank yo

 

[Spencer101]

Here is a link to a sample .xlsx I am using on Dropbox

http://dl.dropbox.com/u/1185462/Sample.xls

Currently I am copying the data in column B and pasting it as a valu
into column A. It would be great if I could use a formula to get
static text value in column A since my original column E values ar
going to change quite often

In addition, is there a way to trim the "CAL" and the ".PDF" in a singl
formula? Currently I have it as two separate formulas (columns C an
D)

Thank you very much

Enter *=MID(E2,4,6)* in C2 of your example and copy down. You the
don't need column D so it can be deleted. That's your second quer
dealt with

I'm still not sure I get what you mean for the first one though. Why d
you need to convert the dates to a static value

 

[hbcobra]

Enter *=MID(E2,4,6)* in C2 of your example and copy down. You the
don't need column D so it can be deleted. That's your second quer
dealt with.

Perfect, thank yo

 

[zvkmpw]

I used a formula to convert text into a specific date value. Now I

would like a formula to convert that result into text.

The TEXT function may provide what you need.

With a date in A1, try
=TEXT(A1,"Mmm dd, yyyy")
or
=TEXT(A1,"mm/dd/yy")
or
=TEXT(A1,"Mmmm d, yyyy")