Updated: March 25, 2023
83 Views
Was it helpful?
author
by Dmytro Sywyi
Tech Expert & Writer
861 resolved issues

I have a politics dataset where 0 means an incumbent won an election and 1 means a challenger won

I was wondering if there was a way to assign the word "Incumbent" to every value of zero and "Challenger" to every 1 on my google sheet
author

Hello, thank you for using Howly. I’ll be happy to help you out! May I ask your name?

Customer Replay

*****

author

Nice to meet you, *****!
Do you want to replace the numbers with the appropriate words in the table?

Customer Replay

yes! And I was trying to do this in a new column so I didn't have to delete the column of 0s and 1s (if possible)

author

Got it
*****, I suggest you use the Find and Replace function in the Google Sheets to replace all 0 and 1 values with the words. It would change the rows though
Do you want to try the replacement function? I can instruct you on this, *****

Customer Replay

yes i will try that first

banner 3
author

Okay
Please, follow the instructions below:

  1. Click Edit.
  2. Next to "Find," type the word you want to find, If you want to replace the word, enter the new word
    next to "Replace with."
  3. To search for the word, click Find.
  4. Optional: Narrow your search by using an option below.
    Match case: Matches only words with the same capitalization.
    Match using regular expressions: In Google Docs, matches words based on regular expressions.
  5. To replace the highlighted word, click Replace. To replace the word every time it’s used, click Replace all.
    Is everything clear with the provided instruction?
Customer Replay

yes! it worked! thank you

author

Great!
I’m glad I was able to get that sorted out for you. Is there anything else I can assist you with today?

Customer Replay

thats all. thank you again!

author

You are welcome!
Please feel free to contact us at any time. We'll be happy to help you.

banner 6
https://imagedelivery.net/cT5c9Z7JJOphL0SI-n4Eyw/04f009c0-b2dc-43cf-8ceb-410d5a1eb100/width=80
Our expert Dmytro is online and ready to resolve your issues
861 resolved issues
Share on:
Copy to clipbord
Was it helpful?

Get answers until you're satisfied

/images/experts/tech/DannisK.webp
/images/experts/tech/StacyS.webp
/images/experts/tech/BorisP.webp

14 verified experts are online now

Eugene D.

Expert's Assistant

Eugene D.
Ask your question here

No comments yet...

What about starting a discussion? Be the first to share your thoughts!

Write a comment

We use cookies to improve your browsing experience on our site, show personalized content and targeted ads, and analyze site traffic.
More info