Hi there

I have several cells in a sheet from which I would would like to extract text from the middle of the string and concat the word actual on the end. e.g

b3 contains:

00 PRELIMINARIES - FORECAST

In the cell below that string, I would like to extract the word "preliminaries" and add the word "actual" to the end of it (result = "Preliminaries actual" (in sentence case is possible))

b5 contains:

15 STRUCTURAL STEEL - FORECAST

In the cell below I would like to extract the words "Structural steel" and add the word "actual" to the end of it (result = "Structural steel actual" (in sentence case is possible))

Some of the strings have two words I would like to extract and some only have a single word - if somenone could assist with a formula that would work in both cases it would be great.

Thanks in advance