Hello!
New user on this Forum, with extensive Excel experience.
I'm stuck on how to combine the texts in two columns in Excel.
Concat Issue.jpg
I'm having the following issues:
I have a Column A, and Column B with text values;
For example
Column A with "Enrolled", and blanks, and Column B with "Enrolled", and blanks
Some of these text values are side by side which lets me know, they are confirmed as "Enrolled" based on two criteria searches using xlookup.
Some of these text values, are TRUE for Column A, and TRUE for Column B. I want Column C to "Concat" these, or combine them to say "Enrolled". I do not want to actually use Concat because that might give me "EnrolledEnrolled", or "Enrolled Enrolled." I simply want it to return the text "Enrolled", if Column A:Column B contains text "Enrolled". Any ideas on how I could do this. I did try a concat, and it doesn't really look right, or return the values 100% of the time.
I should also mention that the texts in those columns are "Enrolled" as a result of a formula. Does that matter?
Need the community's help! Thanks!
Attachments are iffy at the moment since the source is HIPAA protected. -But might create a ghost sheet if necessary.
Bookmarks