Replace range of numeric values with text

Closed

mat7 - Feb 16, 2010 at 02:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 16, 2010 at 05:28 PM

Hello,

I have an Excel report and I need to change all numercial values that are less than 5 to "NIL" and all those greater than 5 to "YES".

Im pretty new at macros so can you really spell out for me what needs to be done!!!!!

Thanks.

Replace range of numeric values with text
Replace abbreviation - Guide
Based on the values in cells b77 b81 c77 - Excel Forum
How to increase wifi range from router settings - Guide
How to replace motherboard battery - Guide
Numeric keypad mac - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 16, 2010 at 05:28 PM

when you say all, you mean like every where in the sheet or just a certain column ?

Similar discussions

help me to add particular cells

Clear cell contents based on value of another cell range using VBA

Fill adjacent cell with number from text answer

iTunes says I am synced with another library

Name Values

Similar discussions

Subscribe To Our Newsletter!