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

Hi,

Without seeing some sample data it's difficult to be precise but you should
be able to do it with :-

Data|Text to Columns

If the data are delimited with a comma as in you example simply choose , as
a delimeter and follow the wizard.

Mike

"Michael Koerner" wrote:

> 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
>
>
>
>

Hi Michael

Look at the TextToColumns from the Data menu, and follow the instructions.

Hopes this helps.

---
Per

"Michael Koerner" <(E-Mail Removed)> skrev i meddelelsen
news:(E-Mail Removed)...
>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
>
>
>

Sample data

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Michael Koerner" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>
>
>

Worked like a charm. Thanks very much

--

Regards
Michael Koerner


"Mike H" <(E-Mail Removed)> wrote in message
news:29E1DC4F-C9A0-4E80-8BBE-(E-Mail Removed)...
Hi,

Without seeing some sample data it's difficult to be precise but you should
be able to do it with :-

Data|Text to Columns

If the data are delimited with a comma as in you example simply choose , as
a delimeter and follow the wizard.

Mike

"Michael Koerner" wrote:

> 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
>
>
>
>