| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split up delimited string & insert row below
Hi everyone. Im wondering how i could go about doing this. Ive setup a UDF
and one part looks like the following. A string is passed (rdText) and if it contains a comma I need to break up the delimited text, insert however many rows needed below where the formula is and paste the split up text there. Thanks in advance If InStr(1, rdText, ",") 0 Then For Each iChar In Split(rdText, ",") If iChar < "" Then 'insert row 'paste value to the new row End If Next iChar End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create comma-delimited string from dynamic range? | Excel Discussion (Misc queries) | |||
| Sum delimited values in text string if... | Excel Worksheet Functions | |||
| Split non delimited data into multiple cells | Excel Worksheet Functions | |||
| Copy tab delimited string to worksheet row - VB6 application | Excel Programming | |||
| Parse a space delimited string into unique columns | Excel Programming | |||
Threaded Mode
