You cannot delete the original column before changing the formulas to values.

Select the formula column and Copy.

Now, in place, Paste SpecialValuesOKEsc.

Delete original column.


Gord Dibben MS Excel MVP


On Tue, 10 Oct 2006 12:36:02 -0700, Mary wrote:

Thanks, that worked great! Now I want to delete the column that references
that formula, but I get "ref" in the column that I put the formula. Is there
a way to delete that column but still keep my formula intact?

"Boo" wrote:

=A1 & " " & B1

or

=A1 & " - " & B1

Where,

A1 = First part of text (or numbers)
B1 = Second part of text (or numbers)

Substitute A1 / B1 with the relevant cells in your spreadsheet

"Mary" wrote:

I put in a formula to combine a string of words with numbers and would like a
space or dash to go in between. How do I do this?