Splitting Cells with Commas

[Angel160]

I have inherited a spreadsheet listing clients' addresses. Each client's full address is written in just one cell and separated by commas (e.g. 1 High Street, Brighton, East Sussex, BN1 1AB). What I would like is for each component of the address (i.e. 1 High Street) to be listed in its own individual cell. Is there any easy way to do this, as I'm a bit stumped at the moment!

Thank you

[swatsp0p]

Use Data>Text to Columns...

follow the prompts, selecting "comma" as the delimiter

Good Luck

Bruce