Just want the number

[VBA Beginner]

Hello,

When I am using a web query to pull data from a website onto Excel, I am getting the cells populated with High -6 C when I just want -6. Is there a formula I can use or setting I can change to just get the -6? Thanks.

Chris

[Trebor76]

Hi Chris,

Assuming the first cell populated is A1, try the following formula:

=LEFT(A1,(SEARCH(" ",A1)-1))

Hope this solves the problem.

Cheers,

Robert

[daddylonglegs]

Hello,

When I am using a web query to pull data from a website onto Excel, I am getting the cells populated with High -6 C when I just want -6. Is there a formula I can use or setting I can change to just get the -6? Thanks.

Chris

If the data always ends with " C" or similar

=MID(LEFT(A1,LEN(A1)-2),FIND(" ",A1)+1,255)