Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
NEED EXCEL MACRO TEXT-PARSING GURU!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing text | Excel Worksheet Functions | |||
Parsing / seperating text string in excel cell | Excel Discussion (Misc queries) | |||
Parsing text | Excel Discussion (Misc queries) | |||
Parsing text in Excel | Excel Worksheet Functions | |||
Hoping a guru can help this novice out with a simple macro | Excel Programming |