Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-11-2016, 09:18 AM
AVWork AVWork is offline How to compare 2 cells with text and extract diferences to a 3rd one Windows 7 64bit How to compare 2 cells with text and extract diferences to a 3rd one Office 2013
Novice
How to compare 2 cells with text and extract diferences to a 3rd one
 
Join Date: Oct 2016
Posts: 2
AVWork is on a distinguished road
Default How to compare 2 cells with text and extract diferences to a 3rd one

Hello,



I have 2 columns with text in cells. Each cell has a concatenation of names, separated by ";". What I have looks like this (simplified example):

Column A

apple (1); orange (2); pear (3)


Column B

apple (1); pear (3)


I need to extract to column C the names in column A that are not in column B. So I should get to "orange (2)" in Column C.

Can anyone give me a hint on how to solve this, please?

Thanks in advance,
AV
Reply With Quote
  #2  
Old 10-15-2016, 05:35 AM
cobbe cobbe is offline How to compare 2 cells with text and extract diferences to a 3rd one Windows 10 How to compare 2 cells with text and extract diferences to a 3rd one Office 2016
Novice
 
Join Date: Mar 2016
Posts: 6
cobbe is on a distinguished road
Default

Is that ok for you?
Attached Files
File Type: xlsx cobbe_MSForum.xlsx (9.8 KB, 14 views)
Reply With Quote
  #3  
Old 10-18-2016, 01:44 AM
AVWork AVWork is offline How to compare 2 cells with text and extract diferences to a 3rd one Windows 7 64bit How to compare 2 cells with text and extract diferences to a 3rd one Office 2013
Novice
How to compare 2 cells with text and extract diferences to a 3rd one
 
Join Date: Oct 2016
Posts: 2
AVWork is on a distinguished road
Default

Thanks, cobbe, but I'm afraid it did not work for me.

Just to clarify something: in cell A1 I have "apple (1); orange (2); pear (3)" and in cell B1 "apple (1); pear (3)".

Thanks anyway!
Reply With Quote
Reply

Tags
compare;extract;diference

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to compare 2 cells with text and extract diferences to a 3rd one Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match krispykreme Excel Programming 1 09-09-2016 11:25 AM
How to compare 2 cells with text and extract diferences to a 3rd one Automatically extract cells to summary table taryn Excel 2 05-04-2016 04:50 AM
How to compare 2 cells with text and extract diferences to a 3rd one Formula, Compare two cell's text and based on results output a number Offrddrver Excel 4 03-23-2016 11:32 PM
Compare text from Bookmark with text from Text box Byron Polk Word VBA 4 07-30-2014 06:18 AM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft