software

Thanks....I'm amazed! I wish I had that kind of Excel knowledge.
I did forget to mention 1 thing though....I need to split the name into 2
colums...First Name and Last Name. Would that be done with a seperate
formula afterwords, and if so, what would that be?

Thank you so much!

Hi!

Maybe this will get you started in the right direction:

The sample you posted is in the range of Sheet1 A1:A7.

Enter this formula in B1 and copy down to B7:

=IF(ISERROR(FIND(quot;:quot;,A1)),A1,MID(A1,FIND(quot;:quot;,A1) 2 ,255))

B1:B7 will now look like this:

Joe's Bar and Grill
1000 Somewhere Dr
City ST Zip
Joe Schmoe
800-000-000
800-000-000
WhoKnowsThen you can get rid of the formulas by converting those to constants.

Now, how you proceed depends on whether each group has *exactly* the same
number of rows of info. Are there empty rows between each group?

You could use a formula like this on Sheet2 that will transpose the data
from Sheet1:

=INDEX(Sheet1!$B:$B,(ROWS($1:1)-1)*7 COLUMNS($A:A))

Copied across then down.

That will give you the result you're looking for:

gt; Joe's..... 1000 S... Joe 800-... 800-. Whoknows

Biff

quot;Dan Bquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have a Word Document (Office 2003) with lots of names and addresses that
gt; I need in Excel so I can add them to another list to do a data import.
gt;
gt; The data in Word is like this:
gt;
gt; Joe's Bar and Grill
gt; 1000 Somewhere Dr
gt; City ST Zip
gt; Contact: Joe Schmoe
gt; Phone: 800-000-000
gt; Fax: 800-000-000
gt; County: WhoKnows
gt;
gt; If I copy and paste that into Excel, of, it puts it in the same column,
gt; each line on a row.
gt;
gt; This is how I need it in Excel (in Columns):
gt;
gt; Company Address Contact Phone Fax County
gt; Joe's..... 1000 S... Joe 800-... 800-. Whoknows
gt;
gt; I need to get it into columns, but I don't want the words Contact, Phone,
gt; Fax etc to show up next to all the names, phone numbers etc. I hope that
gt; makes sense.
gt;
gt; So...how do I do it?
gt;
gt; Thanks,
gt;
gt; Dan
And another thing related to last part of your first post....each group does
not have the same number of rows. Some have 4 rows some have 8. And yes,
there is a blank row between each group.quot;Dan Bquot; gt; wrote in message
...
gt; Thanks....I'm amazed! I wish I had that kind of Excel knowledge.
gt; I did forget to mention 1 thing though....I need to split the name into 2
gt; colums...First Name and Last Name. Would that be done with a seperate
gt; formula afterwords, and if so, what would that be?
gt;
gt; Thank you so much!
gt;
gt;
gt;
gt;
gt; Hi!
gt;
gt; Maybe this will get you started in the right direction:
gt;
gt; The sample you posted is in the range of Sheet1 A1:A7.
gt;
gt; Enter this formula in B1 and copy down to B7:
gt;
gt; =IF(ISERROR(FIND(quot;:quot;,A1)),A1,MID(A1,FIND(quot;:quot;,A1) 2 ,255))
gt;
gt; B1:B7 will now look like this:
gt;
gt; Joe's Bar and Grill
gt; 1000 Somewhere Dr
gt; City ST Zip
gt; Joe Schmoe
gt; 800-000-000
gt; 800-000-000
gt; WhoKnows
gt;
gt;
gt; Then you can get rid of the formulas by converting those to constants.
gt;
gt; Now, how you proceed depends on whether each group has *exactly* the same
gt; number of rows of info. Are there empty rows between each group?
gt;
gt; You could use a formula like this on Sheet2 that will transpose the data
gt; from Sheet1:
gt;
gt; =INDEX(Sheet1!$B:$B,(ROWS($1:1)-1)*7 COLUMNS($A:A))
gt;
gt; Copied across then down.
gt;
gt; That will give you the result you're looking for:
gt;
gt;gt; Joe's..... 1000 S... Joe 800-... 800-. Whoknows
gt;
gt; Biff
gt;
gt; quot;Dan Bquot; gt; wrote in message
gt; ...
gt;gt; Hi,
gt;gt;
gt;gt; I have a Word Document (Office 2003) with lots of names and addresses
gt;gt; that
gt;gt; I need in Excel so I can add them to another list to do a data import.
gt;gt;
gt;gt; The data in Word is like this:
gt;gt;
gt;gt; Joe's Bar and Grill
gt;gt; 1000 Somewhere Dr
gt;gt; City ST Zip
gt;gt; Contact: Joe Schmoe
gt;gt; Phone: 800-000-000
gt;gt; Fax: 800-000-000
gt;gt; County: WhoKnows
gt;gt;
gt;gt; If I copy and paste that into Excel, of, it puts it in the same column,
gt;gt; each line on a row.
gt;gt;
gt;gt; This is how I need it in Excel (in Columns):
gt;gt;
gt;gt; Company Address Contact Phone Fax County
gt;gt; Joe's..... 1000 S... Joe 800-... 800-. Whoknows
gt;gt;
gt;gt; I need to get it into columns, but I don't want the words Contact, Phone,
gt;gt; Fax etc to show up next to all the names, phone numbers etc. I hope that
gt;gt; makes sense.
gt;gt;
gt;gt; So...how do I do it?
gt;gt;
gt;gt; Thanks,
gt;gt;
gt;gt; Dan
gt;
gt;