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 |
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 |
All times are GMT +1. The time now is 01:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com