Forum Message

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

Many thanks again - the -
=IF(LEFT(A2,7)="Peanuts",MID(A2,8,999),IF(LEFT(A2,9)="Butternut",MID(A2,10,999),A2))
works well (with slight adjustment) and just needs to be located in a new col and then its output copied (to a new col also) using Paste Special Values so that the formula once used can the disposed of. I'm not sure what the max characters I have in the cells its possibly 2000 ish (so I changed the 999 to 2000)- it seems the max allowed in a cell is 32k - can that be right?

Metteo - the VBA RemoveText() is brilliant also! but in my case it conks out with "Out of Memory" after its processed about 30 cells. Could this be due to there being too much txt in one cell for it to handle?

Just to confirm, the two words I need stripped out are at the start of the line only.

Thanks.


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