Forum Message

Topic: Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it
Posted by: Matteo Castagna
Date/Time: 18/03/15 16:22:00

Maybe easier. Place your cursor on the top cell of the relevant column and run this:

Public Sub RemoveText()

For Each Cell In ActiveSheet.Range(Selection, Selection.End(xlDown)).Cells
    ActiveCell.Value = Replace(ActiveCell.Value, "Peanuts ", "")
    ActiveCell.Value = Replace(ActiveCell.Value, "Butternut ", "")
    ActiveCell.Offset(1).Select
Next Cell

End Sub

Entire Thread
TopicDate PostedPosted By
Excel - removing words at start of cell - replace can't do it18/03/15 13:31:00 George Turner
   Re:Excel - removing words at start of cell - replace can't do it18/03/15 13:40:00 Dan Murphy
      Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 15:13:00 Matteo Castagna
   Re:Excel - removing words at start of cell - replace can't do it18/03/15 14:33:00 Will Watson
      Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 15:05:00 Andrew Cumming
         Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 15:20:00 Andrew Cumming
      Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 15:14:00 Matteo Castagna
         Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 15:21:00 Will Watson
            Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 15:27:00 Matteo Castagna
      Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 15:47:00 George Turner
         Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:04:00 Will Watson
            Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:22:00 Matteo Castagna
               Re:Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:33:00 Will Watson
                  Re:Re:Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:34:00 Matteo Castagna
                     Re:Re:Re:Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:37:00 Will Watson
                        Re:Re:Re:Re:Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:53:00 Matteo Castagna
   Re:Excel - removing words at start of cell - replace can't do it18/03/15 15:12:00 Matteo Castagna
      Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:45:00 George Turner
         Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:53:00 Will Watson
         Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 16:56:00 Matteo Castagna
            Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it18/03/15 18:35:00 John Ridout
   Re:Excel - removing words at start of cell - replace can't do it18/03/15 18:50:00 Peter Grist

Forum Home