Return value from a collum after a lot of blanks

Hey, I wanna know if there's a way of return the text or value from a line with a lot of blanks in the middle.

Like in the cell a1 I want the formula to be and in F1 is the data I wanna copy.

In b1:F1 there are only blanks '" or spaces like " ". That's the problem.

The second line is like the other but the data is on G instead F.

Can you guys help me