Joining/ Fusing two columns and its contents
Hello all!
My problem is that I have two columns with lots of data in them, say column A and column B. In some cases the data in column A&B are the same, in other cases, one column has data while the other does not. I would like to join the two into one column.
(I would use the "&" function but that wouldn't work where the data is duplicated.)
Thanks in advance for any help
You can test if they match and join as needed, e.g.
Formula:
Please Login or Register to view this content.
There are other ways to combine cells using CONCAT, TEXTJOIN, etc.
Welcome to the forum.
Try this:
=IF(AND(A1=B1,A1<>""),A1,A1&B1)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you Ali! this worked perfectly
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks