On Wed, 11 Oct 2006 14:07:01 -0700, nmp wrote:

I need to be able to pull a set number of characters from a cell, but I do
not what to cut off a word if that set number ends up in the middle of a word.

For example I have: 11 x 8-1/2, 80# Patient Education Shell #501324 CREAM .
By using a LEFT(A2,50) it cuts off the EAM in CREAM. I actually want to cut
off the whole word and put it in a different cell. Make sense? Is that
possible?

Thanks!

Posting in multiple threads is confusing.

You have two solutions posted about five hours earlier than this. Was there a
problem with those solutions?
--ron