DataText to columns

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Gary in Alaska" <Gary in wrote in message
...
I have a Excel spreadsheet that has complete addresses in one cell. (ie 123
Washington Street, Seattle WA 98111). I wish to put each item in separate
cells for use in a database. Is there an easy way to do this using a
function
or ??