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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailing address block: sorting 1 row to columns 1
Validation Selection 2
Dependent Drop Down 3
Figuring out a lengthy formula. Probably quite simple... 3
SQL "IF" Question 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
text not always in same cell 2

Back
Top