Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split text to compare
Dear all
I have a code extracted A1 from the system and looks like. Bill.Eko1 Bill.Eko37 Bill.Eko123 There is any possible way to keep from the code the right part of the code, anything after to dot (Eko1, Eko37, Eko 123.) and compare it with a text in next cell B1 To compare them in C1. Thanks in advance Manos |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split text to compare
Something like this maybe...
=MID(A1,FIND(".",A1)+1,99)=B1 Rick "Manos" wrote in message ... Dear all I have a code extracted A1 from the system and looks like. Bill.Eko1 Bill.Eko37 Bill.Eko123 There is any possible way to keep from the code the right part of the code, anything after to dot (Eko1, Eko37, Eko 123.) and compare it with a text in next cell B1 To compare them in C1. Thanks in advance Manos |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split text to compare
Here is another way to do it also...
=COUNTIF(A1,"*."&B1)=1 Rick "Rick Rothstein (MVP - VB)" wrote in message ... Something like this maybe... =MID(A1,FIND(".",A1)+1,99)=B1 Rick "Manos" wrote in message ... Dear all I have a code extracted A1 from the system and looks like. Bill.Eko1 Bill.Eko37 Bill.Eko123 There is any possible way to keep from the code the right part of the code, anything after to dot (Eko1, Eko37, Eko 123.) and compare it with a text in next cell B1 To compare them in C1. Thanks in advance Manos |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split text to compare
Thanks
"Rick Rothstein (MVP - VB)" wrote: Something like this maybe... =MID(A1,FIND(".",A1)+1,99)=B1 Rick "Manos" wrote in message ... Dear all I have a code extracted A1 from the system and looks like. Bill.Eko1 Bill.Eko37 Bill.Eko123 There is any possible way to keep from the code the right part of the code, anything after to dot (Eko1, Eko37, Eko 123.) and compare it with a text in next cell B1 To compare them in C1. Thanks in advance Manos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to split up text | Excel Worksheet Functions | |||
Split a text | Excel Worksheet Functions | |||
Split text without using data-text to columns | Excel Discussion (Misc queries) | |||
Split Text | Excel Discussion (Misc queries) | |||
text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) |