NEED EXCEL MACRO TEXT-PARSING GURU!
From: amywolfie (amywolfie_at_verizon.net)
Date: 05/17/04
- Next message: Tom Ogilvy: "Re: Hide Rows If Cell Value = False"
- Previous message: Dick Kusleika: "Re: Edit Get External Data Queries"
- Next in thread: Tom Ogilvy: "Re: NEED EXCEL MACRO TEXT-PARSING GURU!"
- Reply: Tom Ogilvy: "Re: NEED EXCEL MACRO TEXT-PARSING GURU!"
- Messages sorted by: [ date ] [ thread ]
Date: 17 May 2004 10:34:29 -0700
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
- Next message: Tom Ogilvy: "Re: Hide Rows If Cell Value = False"
- Previous message: Dick Kusleika: "Re: Edit Get External Data Queries"
- Next in thread: Tom Ogilvy: "Re: NEED EXCEL MACRO TEXT-PARSING GURU!"
- Reply: Tom Ogilvy: "Re: NEED EXCEL MACRO TEXT-PARSING GURU!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
