ExcelBanter - Combine two columns and delete original

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combine two columns and delete original (https://www.excelbanter.com/excel-discussion-misc-queries/193740-combine-two-columns-delete-original.html)

like to know

Combine two columns and delete original

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

Jim Thomlinson

Combine two columns and delete original

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

All times are GMT +1. The time now is 06:57 AM.