Do you have a column of mixed numeric and text entries and you want to
delete the last text entry? What if the last text entry is more than
one word, delete only the last word or the entire entry?

This will probably require VB code to accomplish.

More details, please....


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=346091