Copy cell contents as is unless contains text in which case replace

**xonacs** · 02-07-2018, 10:58 AM

HI guys my first post here, I have I think an easy one.

I have contents in cells A1-Z10. These cells have a numerical value or a text value (either DNS or DNB). I want to copy the contents of these cells to A11-Z20 based on the conditions:

If cell A1-Z10 has a numerical value, copy as is;
If cell A1-Z10 contains the text DNS or DNB, replace with 0.

Any help appreciated.

**Special-K** · 02-07-2018, 11:04 AM

in A11
=IF(OR(A1="DNS",A1="DNB"),0,A1)
copy across and down as far as Z20

NOTE: This new data is still dependent on the data in A1:Z10.
If you're going to delete A1:Z10 you will need to copy/paste values on the A11:Z20 range before deleting A1:Z10

**xonacs** · 02-07-2018, 12:00 PM

Thanks, works perfectly

Copy cell contents as is unless contains text in which case replace

LinkBack

Thread Tools

Rate This Thread

Display

Copy cell contents as is unless contains text in which case replace

Re: Copy cell contents as is unless contains text in which case replace

Re: Copy cell contents as is unless contains text in which case replace

Thread Information

Users Browsing this Thread

Similar Threads

Copy cell contents as text to clipboard as text - keyboard shortcut?

Macro text replace with Cell contents

Find and Replace the contents of one cell with the contents of another

Ctrl + J to find and replace Alt + Enter in multi line cell contents or Text to Columns

[SOLVED] Macro to copy cell contents then used Find & Replace to put text elswhere.

Copy contents of cell and paste in text box

[SOLVED] Can I copy cell contents to an autoshape as text using a macro?

Bookmarks

Bookmarks

Posting Permissions