Is there a way to remove the formula but keep the result from the formula?
For example, I projected dates from previous dates for scheduling purposes. I
now need to combine all of the dates formulated in 1 column as opposed to 3.
However, the formulas are not transfering. Any ideas?

If you have dates in A1 and B1 & you want to combine them in C1
then use this formula in C1
="First date: "&TEXT(A1,"mm/dd/yy") & " Second date: " & TEXT(B1,"mm/dd/yy")

You can change the format you want...

Also to replace a formula with a value
Copy the celll and then paste special as values...

"Anita" wrote:

Is there a way to remove the formula but keep the result from the formula?
For example, I projected dates from previous dates for scheduling purposes. I
now need to combine all of the dates formulated in 1 column as opposed to 3.
However, the formulas are not transfering. Any ideas?

Copy then Paste SpecialValues.


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 12:05:01 -0700, Anita
wrote:

Is there a way to remove the formula but keep the result from the formula?
For example, I projected dates from previous dates for scheduling purposes. I
now need to combine all of the dates formulated in 1 column as opposed to 3.
However, the formulas are not transfering. Any ideas?

Paste Special, Values.

Anita wrote:

Is there a way to remove the formula but keep the result from the formula?
For example, I projected dates from previous dates for scheduling purposes. I
now need to combine all of the dates formulated in 1 column as opposed to 3.
However, the formulas are not transfering. Any ideas?