With the data in cell C1 the below macro will extract the information and
write to colA starting from Row1....Without using macros you can try out
Data--Text to Columns with semicolon as delimiter

Sub ExtractCellData()
Dim intTemp As Integer
Dim strData As String
Dim arrData As Variant
strData = Range("C1")
arrData = Split(strData, ";")
For intTemp = 0 To UBound(arrData)
Range("A" & intTemp + 1) = Trim(arrData(intTemp))
Next
End Sub


If this post helps click Yes
---------------
Jacob Skaria


"dstiefe" wrote:



I have a lot of data in one cell in excel...and the data looks like this...

; ;

I want to copy the text between each semilcolon...then past it to a new cell..

how do i loop through the cell and copy the data between each semicolon?

Thank you