Forum Discussion
Excel: replace multiple values with a single value
Hi everyone
I have a column with some cells blank and some cells featuring multiple email addresses. I want to replace the email addresses with a Yes. Can you tell me how to do this automatically. Thank you.
2 Replies
If there are only blanks and texts (okay, they are email addresses) you may Ctrl+H, Find: * , Replace with: Yes
and Replace All.
Or formula with similar logic in next column.
SergeiBaklan Ah, yes, that sounds like the one! I will try it, thank you so much. have a good day!
