Hello,

Can we use "*" to replace any text or spaces in macros ?

For example :

1)is string " quite new book xxxx " the same as string
" quite new" & "*" , probably not , I tried to do it like that but
it wasn't working at all.

2) how to write it in macro , if I want to compare a cell that is filled
only with a text and other cell if there is the same text but there are
also spaces and other text?


If there is the same text in both column, despite some additional text
or spaces in one cell, I want to offset(0,1) it.


Thank you very much for help

--
Tomek

if Instr(1,LargeString, SmallerString,vbTextCompare) 0 then

for example:
? instr(1,"AbCdEfGh","cde",vbTextCompare)
3


--
Regards,
Tom Ogilvy

"Tomek" wrote in message
...
Hello,

Can we use "*" to replace any text or spaces in macros ?

For example :

1)is string " quite new book xxxx " the same as string
" quite new" & "*" , probably not , I tried to do it like that but
it wasn't working at all.

2) how to write it in macro , if I want to compare a cell that is filled
only with a text and other cell if there is the same text but there are
also spaces and other text?


If there is the same text in both column, despite some additional text
or spaces in one cell, I want to offset(0,1) it.


Thank you very much for help

--
Tomek