separating data into separate columns

[Seraya]

Hi,

I have two colums of data. The second column has the street address,
the suburb and the postcode in the one column. The suburb is in
capital letters. Is there a way to separate the data in this second
column into three columns, that is, one for the street address, the
next for the suburb and the third for the postcode, besides the long
way around of copying and pasting each into separate columns.

Perhaps a macro - I don't know how to write macros though.

Any help would be much appreciated.

seraya

 

[JE McGimpsey]

Hi,

I have two colums of data. The second column has the street address,
the suburb and the postcode in the one column. The suburb is in
capital letters. Is there a way to separate the data in this second
column into three columns, that is, one for the street address, the
next for the suburb and the third for the postcode, besides the long
way around of copying and pasting each into separate columns.

Perhaps a macro - I don't know how to write macros though.

Any help would be much appreciated.

Try Data/Text to columns. If your address and suburb are separated by
commas, try selecting Delimited on the first pane of the dialog, then
check comma as the delimiter. Then use Text to columns again using the
space character as a delimiter to separate suburb and postcode.