ExcelBanter - formula help C3 = B3

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

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

- - formula help C3 = B3 (https://www.excelbanter.com/excel-discussion-misc-queries/178491-formula-help-c3-%3D-b3.html)

Richard

formula help C3 = B3

If C3 = B3, is there a way to delete the contents of B3 and keep the contents
in C3

OssieMac

formula help C3 = B3

You could select C3 and then Copy-Paste Special-Values before deleting B3.
--
Regards,

OssieMac

"Richard" wrote:

If C3 = B3, is there a way to delete the contents of B3 and keep the contents
in C3

Gord Dibben

formula help C3 = B3

First copy C3 and Paste SpecialValues

Then delete B3

Gord Dibben MS Excel MVP

On Sun, 2 Mar 2008 14:17:01 -0800, Richard
wrote:

If C3 = B3, is there a way to delete the contents of B3 and keep the contents
in C3

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