Each item of data is a set of words
The words are separated by a space.

In some of your examples, you need the last word in the set to be
encapsulated by single quotes. In other examples, you need the last two
words to be encapsulated.

How can the formula determine which result to produce??
--
Gary''s Student - gsnu200908


"Gotroots" wrote:

I have a list of plant names that need a single quote inserted at the
appropriate location as the examples show.

Weigela Snowflake
Weigela €˜Snowflake

Wisteria sinensis Caroline
Wisteria sinensis €˜Caroline

Vinca minor Alba Variegata
Vinca minor €˜Alba Variegata

Viburnum x rhytidophylloides Willowwood
Viburnum x rhytidophylloides €˜Willowwood

Viburnum plicatum f. tomentosum Lanarth
Viburnum plicatum f. tomentosum €˜Lanarth

Veronica austriaca subsp. teucrium Shirley Blue
Veronica austriaca subsp. teucrium €˜Shirley Blue

Symphoricarpos x doorenbosii Mother of Pearl
Symphoricarpos x doorenbosii €˜Mother of Pearl

Syringa vulgaris Andenken an Ludwig Späth
Syringa vulgaris €˜Andenken an Ludwig Späth

Saxifraga umbrosa var. primuloides Elliott's Variety
Saxifraga umbrosa var. primuloides 'Elliott's Variety'


Much apprieciate any help given