Formulas

[Anita]

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?

 

[Sheeloo]

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...

 

[Gord Dibben]

Copy then Paste Special>Values.


Gord Dibben MS Excel MVP

 

[Bob I]

Paste Special, Values.