LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Comparing text in cells for differences

I want to compare some text in a1 with text in b1 and have Excel place the
differences in c1. Is this possible? The EXACT function only tells me if they
are alike or not with a true or false, even if the only difference is a
capital letter. I could place the text in one sheet and have it compare
with another sheet and have the differences placed in a third sheet, if that
is easier to do. I am using Excel 2003. I know nothing about writing code
or macros. I am fairly new to Excel. I'm not sure, but I think this might
have to be a macro or something, unless there is a function in Excel that
does this. Help me! Please?
--
Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Text to Several Cells Pontus Excel Discussion (Misc queries) 4 July 4th 08 04:01 PM
Comparing cells with text Mortir Excel Worksheet Functions 4 January 3rd 07 10:54 PM
Comparing two workbooks and highlighting the differences Charles C. Excel Discussion (Misc queries) 2 July 26th 06 07:14 PM
comparing text cells Comander Excel Worksheet Functions 2 June 5th 06 10:00 PM
Comparing two data ranges for differences. jason.r.swinehart Excel Discussion (Misc queries) 0 January 12th 06 07:50 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"