Trim
 

Dear All
in below eg I want to extract only NV,MN ,MF and so on which are user name,
LKOC is remaining for all, other thing are differed.


LKOC_NV_SALARY JUL09 Jones
LKOC_MN_SALARY JUL09-2 Jones
LKOC_MF_BU_SAL_JAN 09
LKOC_PP_BU Salary Feb' 09
LKOC_PP_BU Salary Mar' 09

Thanks for your assistance

Trim
 

Try
=TRIM(MID(LEFT(SUBSTITUTE(A1,"_",REPT(" ",99),2),99),6,9))

--
Jacob


"Fareez" wrote:

Dear All
in below eg I want to extract only NV,MN ,MF and so on which are user name,
LKOC is remaining for all, other thing are differed.


LKOC_NV_SALARY JUL09 Jones
LKOC_MN_SALARY JUL09-2 Jones
LKOC_MF_BU_SAL_JAN 09
LKOC_PP_BU Salary Feb' 09
LKOC_PP_BU Salary Mar' 09

Thanks for your assistance

Trim
 

Hi,

If the code to be extracted is always 2 alphabets/numbers, then you may use

=mid(A2,6,2)

A2 has the string. Please note that this formula assumes the the code will
always start from the 6th position

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Fareez" wrote in message
...
Dear All
in below eg I want to extract only NV,MN ,MF and so on which are user
name,
LKOC is remaining for all, other thing are differed.


LKOC_NV_SALARY JUL09 Jones
LKOC_MN_SALARY JUL09-2 Jones
LKOC_MF_BU_SAL_JAN 09
LKOC_PP_BU Salary Feb' 09
LKOC_PP_BU Salary Mar' 09

Thanks for your assistance