S
sylink
Please I have a need for a function or procedure to extract part of
cell content as shown below. Column A contains the list below. I need
to extract NTB, NTB and BND to column B. The numbers of charaters are
fixed from the Left and is space-delimited
AFS 0.00% NGN CENTRAL BANK NTB 08-09-2011
AFS 0.00% NGN CENTRAL BANK NTB 08-09-2011 A
AFS 0.00% NGN CENTRAL BANK BND 08-09-2011
cell content as shown below. Column A contains the list below. I need
to extract NTB, NTB and BND to column B. The numbers of charaters are
fixed from the Left and is space-delimited
AFS 0.00% NGN CENTRAL BANK NTB 08-09-2011
AFS 0.00% NGN CENTRAL BANK NTB 08-09-2011 A
AFS 0.00% NGN CENTRAL BANK BND 08-09-2011