Hi Excel Forum
So it's been a long time since I've used Excel and I have a column that begins with Yes and No values followed by additional text, e.g. (Yes - No data). What I want to do is separate the yes/no values in one column and the additional text into another. I was able to insert a new column and paste the previous column's information into it as a safe guard and make that the new comments column. So my question is how do I remove text following either yes or no from the first column? Thank you.
Bookmarks