I need to split cells on a specific text. On the attached work sheet I need column B split before the work "Total". Usually this would be a job for text to columns, however I cannot use the letter "T" or use a space because there are other "T"s and other spaces...... And for some reason I am unable to attach a work book so suggestions would be helpful anyway.
Thanks
Bookmarks