Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
112
Views
Topic starter
Hi
i have a column that contain a some codes and i want to replace them with more readable text. but i have some criterias
if column C contain "1OT" then "50%"
or
if column C contain "2OT" then "100%"
else
Normal
how can i fix this? Vlookup, If function
Rune
Posted : 10/04/2024 3:24 am
You can do it manually with these steps:
1. Search in column C for your keyword and press Find All:
2. Immediately after you press Find All, press Ctrl+A on your keyboard, this should select all cells that contain the keyword:
3. Close the search dialog (make sure you don't select anything in the sheet after closing search, go directly to formula bar), then type in formula bar 50% and press Ctrl+Enter.
Ctrl+Enter will add the text typed in formula bar in all selected cells:
Posted : 11/04/2024 12:12 am
