NEED EXCEL MACRO TEXT-PARSING GURU!
 

I need to create a matrix with text strings along the lines of the
following:

1a -Take One FC
2b - Take One TOB
3c - Take One TLS
4d - Take One IOL
5e - Take One Servicing
6f - Take One IVR
7g - Take One Mail
8h - Take One Secure Mail
9i - Take One ATM

1a - Instant Prescreen: Initiation - FC
2b - Instant Prescreen: Initiation TOB
3c - Instant Prescreen: Initiation TLS
4d - Instant Prescreen: Initiation IOL Wamu.com
5e - Instant Prescreen: Initiation Servcicing
6f - Instant Prescreen: Initiation IVR
7g- Instant Prescreen: Initiation Mail
8h - Instant Prescreen: Initiation Secure Mail
9i - Instant Prescreen: Initiation ATM

As you can see, the leading and end text will always be the same, but
the middle part of the string will vary in content and length.

Is there a way to create an Excel macro that will insert the middle
part of the string down a series of 9 rows? I don't have a lot of
experience with Excel VB -- mainly Access.

Thanks very much!
Amy

NEED EXCEL MACRO TEXT-PARSING GURU!
 

As you can see, the leading and end text will always be the same,
I guess I am missing how "Take" is the same as "Instant" or "Instant
Prescreen:"

Are these the only two sets of 9 you need to generate?

--
Regards,
Tom Ogilvy

"amywolfie" wrote in message
om...
I need to create a matrix with text strings along the lines of the
following:

1a -Take One FC
2b - Take One TOB
3c - Take One TLS
4d - Take One IOL
5e - Take One Servicing
6f - Take One IVR
7g - Take One Mail
8h - Take One Secure Mail
9i - Take One ATM

1a - Instant Prescreen: Initiation - FC
2b - Instant Prescreen: Initiation TOB
3c - Instant Prescreen: Initiation TLS
4d - Instant Prescreen: Initiation IOL Wamu.com
5e - Instant Prescreen: Initiation Servcicing
6f - Instant Prescreen: Initiation IVR
7g- Instant Prescreen: Initiation Mail
8h - Instant Prescreen: Initiation Secure Mail
9i - Instant Prescreen: Initiation ATM

As you can see, the leading and end text will always be the same, but
the middle part of the string will vary in content and length.

Is there a way to create an Excel macro that will insert the middle
part of the string down a series of 9 rows? I don't have a lot of
experience with Excel VB -- mainly Access.

Thanks very much!
Amy

NEED EXCEL MACRO TEXT-PARSING GURU!
 

Tom:

Unfortunately, no. There are many, many series of these that need to be created.

Thanks,

amy
==

"Tom Ogilvy" wrote in message ...
As you can see, the leading and end text will always be the same,
I guess I am missing how "Take" is the same as "Instant" or "Instant
Prescreen:"

Are these the only two sets of 9 you need to generate?

--
Regards,
Tom Ogilvy

"amywolfie" wrote in message
om...
I need to create a matrix with text strings along the lines of the
following:

1a -Take One FC
2b - Take One TOB
3c - Take One TLS
4d - Take One IOL
5e - Take One Servicing
6f - Take One IVR
7g - Take One Mail
8h - Take One Secure Mail
9i - Take One ATM

1a - Instant Prescreen: Initiation - FC
2b - Instant Prescreen: Initiation TOB
3c - Instant Prescreen: Initiation TLS
4d - Instant Prescreen: Initiation IOL Wamu.com
5e - Instant Prescreen: Initiation Servcicing
6f - Instant Prescreen: Initiation IVR
7g- Instant Prescreen: Initiation Mail
8h - Instant Prescreen: Initiation Secure Mail
9i - Instant Prescreen: Initiation ATM

As you can see, the leading and end text will always be the same, but
the middle part of the string will vary in content and length.

Is there a way to create an Excel macro that will insert the middle
part of the string down a series of 9 rows? I don't have a lot of
experience with Excel VB -- mainly Access.

Thanks very much!
Amy