Convert Range of Cells from 1's and 0's to text

[mgradie]

I used a data collection tool that outputs the results in numbers which I need to convert to text. For example if the question has "yes" and "no" options, I have a series of 1's and 0's. So, I have a spreadsheet of 0 and 1's that I need to convert to text for readability. Sometimes I need to delete the value. Below is an example of what the data look like. I can write VBA code that will convert everything into Yes or No, but can't set it to distinguish the values. I thought it would be easy to find some VBA code but I can't. It seems easy enought but I keep getting sytax errors. Can anyone help me out?

 

[kweaver]

Welcome to Mr. Excel,

Distinguish the values?? What you've shown is only 1 and 0 to convert to, I assume, YES or NO text?!

 

[mgradie]

Welcome to Mr. Excel,

Distinguish the values?? What you've shown is only 1 and 0 to convert to, I assume, YES or NO text?!

Yes. I can change it to all No's or all Yes's, but I can't figure out how to say If the cell value is 0 then change it to No. If the cell value is 1 then change it to Yes. All the VBA I know I learned today. I figured I could find some code and adapt it But after spending most of the day, I turned to this board.

 

[Rick Rothstein]

Put these two lines of code inside your VBA procedure...

Columns("H").Replace 0, "No", xlWhole, , , , False, False
Columns("H").Replace 1, "Yes", xlWhole, , , , False, False

 

[mgradie]

Well, that worked. Thank you very much. I don't understand the syntax completely, but I think I can work with it.