splitting an address ?

[maverickmonster]

I have a excel sheet with addresses in like

123 Way,456 street,newtown,wayaway,xx34 8zz

is there an easy to split these in to there individual components.

 

[xlbo]

Data>Text To Columns> Choose "," as delimeter

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[maverickmonster]

Geoff,

Thanks spot on .

Best wishes

Maverickmonster