i want to truncate anything past the 7th character. is there a way to do
this? The data is pretty uniform, usually has about 12-15 characters,
if that helps.


--
lrod1843
------------------------------------------------------------------------
lrod1843's Profile: http://www.excelforum.com/member.php...o&userid=24346
View this thread: http://www.excelforum.com/showthread...hreadid=387172