Excel Text to Column Using Formula (VBA Function)

Public Function SplitMyData(myCellValue As String, mySeparator As String, i As Integer)

'array Variable
Dim mySplitValue() As String
mySplitValue = Split(myCellValue, mySeparator)

SplitMyData = mySplitValue(i - 1)

End Function

[kevinjones]

Manohar, this is exactly what I need to do. If only it were done without VBA. Corporate doesn't allow VBA, so I can only use a formula. Do you know if a way to get the same result with a formula?

[dadz]

Great help. THANKS A LOT MANOHOR. One additional question. Is it possible to set VBA code so it always work for specific cell so that we dont need to again and again create it in formula bar. Once again THANKS A LOT. Very good video. BR