| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract emails from cells with text | Excel Worksheet Functions | |||
| Extract text on right of various length from cells | Excel Discussion (Misc queries) | |||
| How to extract just text from cells | Excel Worksheet Functions | |||
| Find / Compare Text in 2 different cells | Excel Discussion (Misc queries) | |||
| How do you compare text in cells | Excel Worksheet Functions | |||
Threaded Mode
