move data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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