Re: $$Excel-Macros$$ Re-arrange Imported List from Txt file

Oh goodness gracious, this is too much , i love this. Thanks Ashish, its superb. thanks a lot On Thu, Aug 15, 2013 at 3:17 PM, ashish koul wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (koul.ash...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Re-arrange Imported List from Txt file

try something like this Option Compare Text Sub test() Dim i As Long j = 6 For i = 1 To Range("a65356").End(xlUp).Row Cells(i, 1).Value = Application.WorksheetFunction.Trim(Cells(i, 1).Value) If Cells(i, 1).Value = "Full Name:" Or Cells(i, 1).Value = "Name:" Then