Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two strings that start with the same characters, but at some
unknown and varying point they begin to differ. I want the position number of the first non-matching character. For example: -- table and chair -- table plus chair -- position of first non-matching character is 7 (the "a" in "and", and the "p" in "plus"). In the above example, both strings start out "table ", then start to differ beginning with the 7th character. How can I return the position of the first non-matching character, which in this example is 7? Thanks, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
return a character at a certain position in a string of text | Excel Worksheet Functions | |||
Return position of 2nd, 3rd, ect occurrence of a character in a st | Excel Discussion (Misc queries) | |||
Insert a special character in 1st and last position into a cell | New Users to Excel | |||
sort on character position | Excel Worksheet Functions | |||
Return position for each matching value in entire workbook? | Excel Worksheet Functions |