View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Breaking one column into three

Sample data

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Michael Koerner" wrote in message
...
I was sent a spreadsheet with some 4900 records, that has one column
containing the data for City, Prov, Country. I would like to know how to
break up the one column into three separate columns without having to do
it
one record at a time. I am now down on bended knees pleading for
assistance.TIA

--

Regards
Michael Koerner