Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
spliting text
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
spliting text
got it... thanks -- sungen9 ----------------------------------------------------------------------- sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914 View this thread: http://www.excelforum.com/showthread.php?threadid=53802 |
#3
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spliting a cell | Excel Discussion (Misc queries) | |||
Spliting and combing text down rows in Excel 2007 | Excel Discussion (Misc queries) | |||
Spliting dimensions down | Excel Worksheet Functions | |||
Spliting 1 Text field into 3 | Excel Discussion (Misc queries) | |||
Spliting name | Excel Discussion (Misc queries) |