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 firstname.lastname@example.org
Please send your review and feedback to email@example.com
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 updated my Aadhaar details from Aadhaar update center. It is mentioned that within 72 hours, my details will be update...
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...