"rabc0011" = "abc0011" ????
 

There must be a way to do this... I have a huge table with column A -
file names in a "RABC0011" format on one list and an "ABC0011" on
another list. I am trying to copy certain columns of the R table to
the other table. In order to do this I have to set up a loop to check
if filename equals RABC0011 minus the R, add column F, G and H. Is
there a way to make "Rxxxnnn" = "xxxnnn"?


---
Message posted from http://www.ExcelForum.com/

"rabc0011" = "abc0011" ????
 

sStr = "Rxxxnnn"
sStr1 = "xxxnnn"
if lcase(right(sStr,len(sStr1))) = lcase(sStr1) then

or

if Instr(1,sStr,sStr1,vbTextCompare) = 2 then

--
Regards,
Tom Ogilvy

"hyyfte " wrote in message
...
There must be a way to do this... I have a huge table with column A -
file names in a "RABC0011" format on one list and an "ABC0011" on
another list. I am trying to copy certain columns of the R table to
the other table. In order to do this I have to set up a loop to check
if filename equals RABC0011 minus the R, add column F, G and H. Is
there a way to make "Rxxxnnn" = "xxxnnn"?


---
Message posted from http://www.ExcelForum.com/