Extracting date in desired format

[thisisrahul]

I've data in the below format:-

this is, Just to test, excel possibilities of data extraction

test, data in the below format, thanks

please provide help, if any

<tbody>
</tbody>

i want the above data to be extracted in the below format:-

this is <tbody> </tbody>

Just to test <tbody> </tbody>

excel possibilities of data extraction <tbody> </tbody>

test <tbody> </tbody>

data in the below format <tbody> </tbody>

thanks <tbody> </tbody>

please provide help <tbody> </tbody>

if any <tbody> </tbody>

<tbody>
</tbody>

The above data is comma separated.


_______
Rahul

 

[Rick Rothstein]

Do you really need to do this using a UDF formula? If you do not need the "live" changing ability of a formula (when the source data is changed), I think a macro would be more efficient overall (simply run it if and whenever you make a change to the source data). Here is the macro (data assumed to be in Column A starting in cell A1, output to Column B starting at cell B1)...

[table="width: 500"]
[tr]
	[td]Sub ParseByCommas()
  Dim Combined() As String
  Combined = Split(Join(Application.Transpose(Range("A1", Cells(Rows.Count, "A").End(xlUp))), ","), ",")
  Range("B1").Resize(UBound(Combined) + 1) = Application.Transpose(Combined)
End Sub[/td]
[/tr]
[/table]