VBA to find string that looks like this and also cell below

[mahmed1]

Hi

Im trying to input some code that looks at row A1:Z1 and search to find a character string that looks like this or has this in there
(1 = strongly disagree and 5 = strongly agree)
If that is found - i need to look at the cell directly below it and see if there is any value in it (not blank)
If it empty then i need to extract all the characters before the "(" trimming any end spaces and paste it on to the cell below
If there is a value under the cell below then ignore it and find the next match

There could be many cells that have that match

How can i achieve this please

 

[davesexcel]

Is the cell in row 2, a formula?

 

[mahmed1]

No its a value

 

[mahmed1]

I think ive managed to sort it using the Instr Function

thank you