Thread: Trim
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fareez Fareez is offline
external usenet poster
 
Posts: 25
Default 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