Re: NEED EXCEL MACRO TEXT-PARSING GURU!
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/17/04
- Next message: Frank Kabel: "Re: Hide Rows If Cell Value = False"
- Previous message: TJ Walls: "Delete Worksheet on DeActivate"
- In reply to: amywolfie: "NEED EXCEL MACRO TEXT-PARSING GURU!"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 19:14:44 +0200
Hi
not quite sure but why don't you use the following formula in an
adjacent column
=SUBSTITUTE(A1,"Take One","Instant Prescreen: Initiation")
and copy this down for all rows
-- Regards Frank Kabel Frankfurt, Germany amywolfie wrote: > 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: Frank Kabel: "Re: Hide Rows If Cell Value = False"
- Previous message: TJ Walls: "Delete Worksheet on DeActivate"
- In reply to: amywolfie: "NEED EXCEL MACRO TEXT-PARSING GURU!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
