Hi Guys

I've been struggling with this trying t clean some data. Basically I have a very large data where street names have postcode attached to them such as Harrington Street KW1. I tried using TRIM(LEFT(SUBSTITUTE(A1,"",255)),255)), however this just returns Harrington and leaves Street. In instances where I have street with more one or two strings such Norbury East Avenue KW2, the formula just returns Norbury. Grateful if anyone could assist with formula to extract the street name from the post code.

Many thanks