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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KoolPal - 23 Feb 2004 10:31 GMT

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=-

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 23 Feb 2004 14:04 GMT

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.

Signature

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

> Hello folks,
>
[quoted text clipped - 12 lines]
> Cheers,
> -=KoolPal=-

Reply to this Message