Posted to microsoft.public.excel.programming
|
|
spliting text
=right(a1,2)
=left(a1,len(a1)-2)
--
Regards,
Tom Ogilvy
"sungen99" wrote:
I have in A1 "CNAN6"
I want to strip it into 2 parts.
CNA
and
N6
The N6 is found using =RIGHT(A1,2) so thats easy. But how do I get the
CNA part. Also note that this is not always going to be only 5
characters long. It could be 10. BUT the last two characters will
always be split away from the rest of the string.
Thanks for the help.
--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=538024
|