move data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

<< Jim >> - 17 Jan 2008 16:01 GMT

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.

Reply to this Message

Pete_UK - 17 Jan 2008 16:32 GMT

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

> I have an excel spreadsheet with thousands of rows of data in the format all
> in Column A:
[quoted text clipped - 15 lines]
> What is the easiest way to do these two things?
> Thanks.

Reply to this Message

<< Jim >> - 17 Jan 2008 17:28 GMT

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

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
[quoted text clipped - 16 lines]
> What is the easiest way to do these two things?
> Thanks.

Reply to this Message