Copy the new column and in place, EditPaste SpecialValuesOKEsc

Now delete the original column.


Gord

On Thu, 20 Jul 2006 18:12:06 -0400, herbivore
wrote:


That worked great, but I can't have 2 columns visible in the file. How
do I get rid of the original column with the information still intact?
The program that I'm importing it into won't merge those 2 columns
together and it's not importing correctly.

Thanks for your help.

Gord Dibben MS Excel MVP