Oh, your task is relatively simple — assuming the variation are all ‘the first *X*’ words — since all it takes is a `LEFT()`

and an ugly `SWITCH()`

statement.

The following assumes (1) your list of fifty words is in the field `{50W}`

; (2) the field that determines whether to use the `'1W'`

or `'2W'`

or `'10W'`

formula is called, simply, `{W}`

, and (3) you need variations from `'1W'`

through `'10W'`

.

Here’s the formula:

```
LEFT(
{50W},
SWITCH(
W,
'1W',FIND(',',{50W})-1,
'2W',FIND(',',{50W},FIND(',',{50W})+1)-1,
'3W',FIND(',',{50W},FIND(',',{50W},FIND(',',{50W})+1)+1)-1,
'4W',FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W})+1)+1)+1)-1,
'5W',FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W})+1)+1)+1)+1)-1,
'6W',FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W})+1)+1)+1)+1)+1)-1,
'7W',FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W})+1)+1)+1)+1)+1)+1)-1,
'8W',FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W})+1)+1)+1)+1)+1)+1)+1)-1,
'9W',FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W})+1)+1)+1)+1)+1)+1)+1)+1)-1,
'10W',FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W},FIND(',',{50W})+1)+1)+1)+1)+1)+1)+1)+1)+1)-1
))
```

And here’s a demonstration base showing how it all works together.