Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That did it! Thanks to all for helping with this.
Here is the final macro: Sub FixDescription() Dim rng As Range, cell As Range, iloc As Long Set rng = Range(Cells(2, 3), Cells(Rows.Count, 3).End(xlUp)) For Each cell In rng iloc = InStr(1, cell, " ", vbTextCompare) If iloc < 0 Then cell.Offset(0, 1).Value = Mid(cell.Value, iloc + 1, 255) cell.Value = Mid(cell, 1, iloc - 1) End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rookie question | Charts and Charting in Excel | |||
Rookie needs help! | Excel Discussion (Misc queries) | |||
VBA Help please (rookie issue) | Excel Programming | |||
Rookie question: placing a value into one cell based on a forrmula in another | Excel Programming | |||
VBA rookie question - listbox and GOTO | Excel Programming |