Hi I need to write a funcation or vba code to extract the road name Eg in the the address i want extract before the road one word "RMZ icon, palace road, bangalore " o/p should be palace road I have 500 addresses in that along with road i need first word. Please help
Solved by E. S. in 21 mins