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
Bookmarks