I'm pretty new to excel & working from home so sorry if this sounds a stupid question! I'm not even sure of the correct terminology!

I need to take some name and address info from another source (copied from email) which will be formated in the following way and then I need it to automatically go into relevant colums? Is this possible or am I wishfull thinking and in reality need to do it the long winded way of cutting & pasting each word?

eg.

Mr Brown, 1 the street, townville, somethingshrie, w12 34t

to automatically split into labelled colums eg.
Name, address, Town, County, postcode

With Many Thanks
Jamlagoon