Looking for appropriate function to extract words in excel cell

[JayshreeJK]

HI

I am a list of addresses where I have to extract the locality only.Locality in Upper Case

For e.g

1. 12 Mahatma Gandhi st TRIOLET
2. Royal Road MON GOUT
3. ROCHE BOIS 12 Nicolay Road

Wish someone can help me find the result.

Thanks & Kind Regards

[TMS]

In the absence of any other response, I can offer a User Defined Function (UDF)

Please Login or Register  to view this content.

Open the VBE by pressing Alt-F11.
Insert a new (Standard) Module.
Copy and Paste the code above into the new module.

In the spreadsheet, call the function using: =GetUC( ... cell address ...), for example, =GetUC(A2)


Regards, TMS