Problem setting variable based on partial cell string

[DaveBlakeMAAT]

Hi all

Sorry I am probably being thick, but I am having a problem setting a variable based on a partial string within a cell.

AccountingYear = Trim(Mid("A5", Find("201", "A5", 1), 4))

It is giving me a syntax error which I suspect is due to the find statement.

My scenario is I have the following text string

"ACCOUNTING PERIOD 1 2016/2017 01-APR-2016 TO 30-APR-2016" in a cell

and I need to be able to extract the accounting period for 1 variable (which I have working using Trim(Mid(Range("A5"), 18, 2)), however I am struggling to extract the year for the 2nd variable.

Any ideas

Regards

Dave

 

[Joe4]

Use:

AccountingYear = Trim(Mid(Range("A5"), InStr(Range("A5"), "201"), 4))

 

[DaveBlakeMAAT]

Thanks Joe

I appreciate your assistance.

Regards

Dave

 

[Joe4]

You are welcome!