Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I replace all 1 values with a tick in an excel column

Status
Not open for further replies.

jeep2001

Programmer
Dec 15, 2005
134
US
I have a column in an Excel sheet that contains a 1 or 0 value. I would love to replace the 1 with a tick or check.
The column contains 4,000 rows, so I need a programmatic way of changing the value. How can i do this in EXCEL?
 
On the Edit menu.... select Replace.
Fill in the appropriate boxes in the Find and Replace popup.


Randy
 
Just in case ---- checkmark is ALT+251

Member AAA - Abolish Abused Abbreviations
 
Find and Replace worked like a charm. Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top