Thread: how do i compare 2 cells and extract the text that is different?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ky1234 ky1234 is offline
external usenet poster
  
Posts: 1
Default how do i compare 2 cells and extract the text that is different?
I have 2 columns that contain text that is different, but almost matches
except for 1 character that does not. i want to find out what is the
character in the cell that does NOT match.
ie.
column a = APTK745 (i want to return the P)
column b = ARTK745 (i want to return the R)
or
column a = ANPF841 (i want to return the F)
column b = ANPE841 (i want to return the E)

Reply With QuoteReply With Quote