Re: NEED EXCEL MACRO TEXT-PARSING GURU!
From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 05/17/04
- Next message: Kim-Anh Tran: "Re: Printing output #### problem!"
- Previous message: Bill: "Find Data in a String"
- In reply to: amywolfie: "NEED EXCEL MACRO TEXT-PARSING GURU!"
- Next in thread: amywolfie: "Re: NEED EXCEL MACRO TEXT-PARSING GURU!"
- Reply: amywolfie: "Re: NEED EXCEL MACRO TEXT-PARSING GURU!"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 14:48:23 -0400
> 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" <amywolfie@verizon.net> wrote in message news:33651c5d.0405170934.4c3e246c@posting.google.com... > 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: Kim-Anh Tran: "Re: Printing output #### problem!"
- Previous message: Bill: "Find Data in a String"
- In reply to: amywolfie: "NEED EXCEL MACRO TEXT-PARSING GURU!"
- Next in thread: amywolfie: "Re: NEED EXCEL MACRO TEXT-PARSING GURU!"
- Reply: amywolfie: "Re: NEED EXCEL MACRO TEXT-PARSING GURU!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
