Guys , Need Advice
Sample data
Column A
EXTR0993809 - Detailed description
I need to split column A and replace (as below)
Column A
Detailed description
Column B
EXTR0993809
Note: Sometimes , Column A may have only detailed description .
Below code does that ,however it takes really long time. Please help to find better solution
Set RNG = wstarget.ListObjects("WorksheetName").ListColumns(COLUMNA).DataBodyRange
For Each Cell In RNG.Cells
If (Left(Split(Cell.Value, " ")(0), 4)) = "EXTR" Then
Cell.Offset(0, off) = Trim(Split(Cell.Value, "-")(0))
str = Split(Cell.Value, "-", 2)(1)
Cell.Value = RemoveLeadingChr(str)
Else: End If
Next Cell
Bookmarks