spliting text

[sungen99]

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]

got it... thanks!

[Tom Ogilvy]

=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
>
>