If...then...else... comparison operator 'contains'

[KoolPal]

Hello folks

I am trying to mail-merge in word 2000 with a data-source of excel 2000

One of my columns has data which start with alphabets follwed by numbers. I need to insert specific text if this data starts with PP

Using the If...then...else... option I am limited to operators such as 'equal to', 'not equal to', etc. I am trying to the operator 'contains'

Can anybody help me with this

Thanks a ton

Cheers
-=KoolPal=-

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Use the Left() function in Excel to create another column of data that
contains the first two characters of the column and then use an If
...Then..Else on that field in the mailmerge main document.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP