Splitting Text

[jo.stanley]

Hi

Hope someone can help. I have an excell cell that contains an address with each part seperated by a comma. Is there any easy way to split this into different cells after each comma.

I.e. currently A1 has Mrs Smith, 125 Smith Street, Smithville, Smithshire

I want it to be Cell A1 Mrs Smith Cell A2 125 Smith Street, Cell A3 Smithville etc.

 

[anandvarma]

use text to column

 

[moonfish]

Here's a guide to the Text To Column feature in Excel:
http://support.microsoft.com/kb/214261

 

[ADAMC]

Look at the text to coluimns feature in excel help menu.

using a comma as your delimiter should do the trick for you.

Any problems post back.

 

[moonfish]

Just a small pointer: your delimiter is not just a comma, it's a comma followed by a space (so it's ", " without the quotation marks).