Replace data in a column

G

Guest

How can I replace data in a column that is between 1 and 10? This way it will
leave any other text there. I think the whole column is formatted as TEXT so
I may be running into a problem there. Will I still be able to create some
sort of formula

If data >1 or <10 then replace with " "
 
D

Dave Peterson

One way...

Select that column
apply data|filter|autofilter
use the arrow dropdown and choose custom
Greater (or greater than or equal to) 1
AND
less than (or less than or equal to) 10

Now select those visible cells
type your new entry
hit ctrl-enter instead of just enter to fill the selected cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Text data using the Data - Subtotal feature 1
VBA- IF statement to replace cell contents 0
Cell not calculating after importing data 2
"Replace all" changes formatting 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Wildcard in the Replace function 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Need help on formula. 6

Top