I have an excel spreadsheet with thousands of rows of data in the format all
in Column A:
Row 1: COMPANY NAME 1 Address
Row 2: Contact1
Row 3: COMPANY NAME 2 Address
Row 4 Contact2
Row 5: COMPANY NAME 3 Address
Row 6: Contact3
Row 7: COMPANY NAME 4 Address
Row 8 Contact4
etc.

What I need to do is two things:
1. I need to seperate the COMPANY NAME into Column B and put the "Address"
in Column C.
2. Move the Contact to Column D

What is the easiest way to do these two things?
Thanks.

Do you have anything between "COMPANY NAME 1" and "Address 1" that
would enable a formula to determine where to split the text? If not,
then is "COMPANY NAME" always the same length, padded with spaces
perhaps?

Pete

On Jan 17, 4:01*pm, "<< Jim >>" <stops...@redmond.com> wrote:
> I have an excel spreadsheet with thousands of rows of data in the format all
> in Column A:
> Row 1: COMPANY NAME 1 Address
> Row 2: Contact1
> Row 3: COMPANY NAME 2 Address
> Row 4 Contact2
> Row 5: COMPANY NAME 3 Address
> Row 6: Contact3
> Row 7: COMPANY NAME 4 Address
> Row 8 Contact4
> etc.
>
> What I need to do is two things:
> 1. I need to seperate the COMPANY NAME into Column B and put the "Address"
> in Column C.
> 2. Move the Contact to Column D
>
> What is the easiest way to do these two things?
> Thanks.

No, there is not any seperator. The only unique thing about "COMPANY NAME"
is that the name is in all CAPITAL LETTERS. Is there a way to seperate that
out? Or, there is a space between the COMPANY NAME and Address.

Thanks.
"Pete_UK" <pashurst@auditel.net> wrote in message
news:34b78b36-62b4-4112-b2f9-ef9fc8ae2caf@f10g2000hsf.googlegroups.com...
Do you have anything between "COMPANY NAME 1" and "Address 1" that
would enable a formula to determine where to split the text? If not,
then is "COMPANY NAME" always the same length, padded with spaces
perhaps?

Pete

On Jan 17, 4:01 pm, "<< Jim >>" <stops...@redmond.com> wrote:
> I have an excel spreadsheet with thousands of rows of data in the format
> all
> in Column A:
> Row 1: COMPANY NAME 1 Address
> Row 2: Contact1
> Row 3: COMPANY NAME 2 Address
> Row 4 Contact2
> Row 5: COMPANY NAME 3 Address
> Row 6: Contact3
> Row 7: COMPANY NAME 4 Address
> Row 8 Contact4
> etc.
>
> What I need to do is two things:
> 1. I need to seperate the COMPANY NAME into Column B and put the "Address"
> in Column C.
> 2. Move the Contact to Column D
>
> What is the easiest way to do these two things?
> Thanks.