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?