Extract Address In excel sheet using formulas and function

S

subh57220

Hi,

I have a problem in excel sheet to extract addresses as in my excel
sheet the address is
(subhankar behera, purunabandhagoda, sainkul, keonjhar, orissa,
758043). But I want to extract it using formulas and it should be show
as subhankar behera, purunabandahgoda


So give me the tips to slove the problem


Regards and Thanks
subhankar
 
G

Graham Mayor

This forum is for Word. Ask Excel questions in an Excel programming forum,

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Top