multiline textbox to datagridview

[iDio]

Hey there,

I have a multiline textbox with this appearence:

A#B
C#
D#E

and i want to populate my datagridview to something like this:

A|BC|D|E

i mean, i want to split when there's a "#" , but i don't want multiline cells in datagridview.

i tried this code:

Dim sup() As String = TextBox1.Text.Split(vbCr, vbLf, vbTab, " "c, "#")
DataGridView1.Rows.Add(sup(0), sup(1), sup(2),sup(3)

but it says it goes outta bounds.. thanks!