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 friends, I have updated my Aadhaar details from Aadhaar update center. It is mentioned that within 72 hours, my details will be update...
Hi everyone, I booked my train ticket even it is in WaitingList. Because, I guessed that, It will get confirmed when chart prepares. Aft...
For the academic purpose i had written a small program in Matlab. I have tried encoding and decoding the image by using Huffman coding. ...