Hi,

Hoping someone can help. I have an entry in Cell A1 that reads something like "FirstName SecondName Age Colour Sport Food Hobby". This is a feed from a third party software that changes periodically. In Cell B2 I would like to put a formula in so that I only get "Food" displayed. I guess this can be achieved using some form of trim and picking up the fact that spaces separate the data in the cell. However, the "Food" length varies in length and the only way of knowing the end of that field is when there is a space after it. Here are two possible examples that may be entered in cell A1:

A1: "Brown Bobby 30 Green Rugby Pasta Fishing"

A1: "Peters John 20 Blue Football Pizza Archery"

In the first example, I would want cell B2 to return "Pasta" and in the second example, I would want cell B2 to return "Pizza"

Is it possible to do this via a formula in B2? If so, grateful if someone could kindly post such an example. This is for a really good cause.

Many thanks,

Nick