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