move data

[Guest]

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.

 

[Pete_UK]

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

 

[Guest]

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