Today I have written one more small macro in Excel to split the data with the delimiter and copy to the columns which are beside to the data.
Dim data As String
Dim values As Variant
Dim i As Long
Set DataRange = Range("A1").CurrentRegion
For Each cell In Range("A1").CurrentRegion
'Getting text from the cell
data = cell.Text
'MsgBox ("Data :" & data)
values = split(data, ",")
For i = 0 To UBound(values)
'MsgBox ("Value is: " & values(i))
'Splitting to other columns
cell.Offset(0, i + 1).Value = values(i)
'Autofit the content to the column
Please send your feedback and comments to email@example.com
Please send your review and feedback to firstname.lastname@example.org
Hi everyone, I booked my train ticket even it is in WaitingList. Because, I guessed that, It will get confirmed when chart prepares. Aft...
Hi friends, I have mistakenly typed the ATM pin 3 times at ATM. My ICICI card was blocked. This was the second time, it happened to me. I h...
For the academic purpose i had written a small program in Matlab. I have tried encoding and decoding the image by using Huffman coding. ...