Formula and VBA to Find symbol in range and place in Range

[menor59]

Can i please request a Formula and VBA for the following???

In the Attached Picture i Have a Range of AC1:AC200 on a sheet called Site TOC

in Column AA of that sheet Put Anything Between IGNORE1 and IGNORE2

on said sheet...

Also need a separate formula for the same thing if possible.

Thank you in Advance..

 

[menor59]

Bump Please.