Hi,

I have a column with a variable length single text string in each cell
between 9 & 36 characters. I want to consistently split or remove the
last (rightmost) 8 characters from this string, and leave the left part
of the string ( like a reverse concatanation). Is there a function to do
this?

Thanks in anticipation.


--
ado1963
------------------------------------------------------------------------
ado1963's Profile: http://www.excelforum.com/member.php...o&userid=30305
View this thread: http://www.excelforum.com/showthread...hreadid=499695