If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JackGombola" wrote in message
...
I have an Excel 2003 spreadsheet with only one column of player data:
column
A. The first three data items in column A are the same for every player:
Name, Address and Phone. Every player also has at least one comment but
could have any number of comments. Each players data is separated from
the
next by a blank cell in column A. Sometimes, a players last few
comments are
blank resulting in multiple blank cells in column A before the data for
the
next player starts.

I need help writing an Excel 2003 VBA macro to:
1. Copy just the players name, but not the Name: label, to column B as
shown.
2. Copy just the address, but not the Address: label, to column C
3. Copy just the phone, but not the Phone: label, to D
4. Combine all of the players comments, but not the original Comment:
label, into one paragraph and paste into E. Repeat the above process,
ignoring any blank rows separating the players, for all the player data in
column A.
A B C D E
Name:John John Main St 555-1212 Plays 1st base. Plays
2nd
Address:Main St Jane Center St 555-1213 Catches well. Has
played
center.
Phone:555-1212
Comment:Plays 1st base
Plays 2nd

Name:Jane
Address:Center St
Phone:555-1213
Comment:Catches well
Has played center.

I've been able to do the easy stuff, repositioning the column headings
etc.
but the variable number of comments entries is giving me trouble as is
removing the labels and colons(:) that precede the data. I'm guessing
that
the latter is done with a find to find the colon(:) but then how do I copy
all the characters to the right?

Thanks is advance for any ideas.
Jack