help me to split the address in one cell

Friends,
i have a address in one cell ie., list of address provided to me in spreadsheet.
eg. 14 thames street sharon sharonshire england 14h 24t.
so this should split as in separate column NO. "14" and in next column field called Street as Thames street",
field called County as "Sharon", field called town as "Sharonshire", city as "england" and Post code as 14h 24t.
So address in single cell should break in the respective fields which i have given.
fields are No. , Street, County, Town, City & Postcode.

pls help me with your possible ideas...
any small ideas would also be help full....

thanks guys.

Originally Posted by dilipandey

Hi Prabhuduraraj,

Address can be separated basis the spaces in between..... I would suggest you to do "Text - to - column" and then you might need to concatenate one or two columns back to achieve your desired result :)


Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Mr. Dilipandey,

Thanks for your valuable idea. Yes i do forgot about Text to column.
Realy thanks for replying my post.

i have one more query in this, what if some address has comma in between, and some are with spaces
as i have given example earlier. i mean a mixture of both type of address then how could i do it!