Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split Function
I am trying to use the split function to return several instances of
substrings within a string. Can you please tell me how to return those values e.g. to a variable Thanks TAM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split Function
Hi
one way: Sub foo() Dim Text_Split As Variant Text_Split= Split(ActiveCell.Value) MsgBox Text_Split(0) MsgBox Text_Split(1) End Sub -- Regards Frank Kabel Frankfurt, Germany TAM wrote: I am trying to use the split function to return several instances of substrings within a string. Can you please tell me how to return those values e.g. to a variable Thanks TAM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nees Function to Split | Excel Worksheet Functions | |||
Split Cell using If or other function | Excel Worksheet Functions | |||
What are the main benifits of using the Split function? | Excel Worksheet Functions | |||
Split Cells using a Function | Excel Worksheet Functions | |||
Split into 2 wrkshts, now function doesn't work | Excel Worksheet Functions |