View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ksenija Ksenija is offline
external usenet poster
 
Posts: 19
Default how to compare parts of text in different cells

HI,

can somebody help me with a problem: I want to write a code which can
compare for example 4 letters in the middle in one cell with for instance 4
letters in the middle in an other cell, and then do something depending on if
these 4 letters are the same or not..

for example, if I have these two different cells, and I want to see if the
second cell has the same 4 digits in the middle..

E224_Gv080326f 3_3_01
E224_Gv080603f 3,2_3_01

I don't want to write a code like "recognize this exact combination of
letters", since I have a lots of different cells and I want to compare them
with eachoter. I want the next cell to be compared with ones before..