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

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

Customer Replay

*****

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)

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

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

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!

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

banner 6

Get answers until you're satisfied

14 verified experts are online now

Expert's Assistant

Ask your question here
Share on:
Copy to clipbord
Was it helpful?
Howly expert is ready to help you with your Website problem

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