Before you delete B and C copy column A and paste special values...
--
HTH...

Jim Thomlinson


"like to know" wrote:

when I combine the two columns (B and C) into A and delete B and C all I end
up with in column a is the formula not the info from column b and c

Can you help

Thanks in advance