How to get values which exists in Second place

[#1]

Hi,

Please find attached excel file.

I need to get only the values which exists in SECOND place without blanks.

For Eg:

 
54 Old Forge Lane, BeachRoad, County Down, US, BT67 U89

I need to get the value BeachRoad only

Please can anyone help me how to get this.

Thanks.

[Anonymous]

Don't forget to use Trim otherwise you will get spaces in the value.