Extraction
 

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

Extraction
 

Assuming you wish to keep column A intact...........

Copy A to B then DataText to ColumnsDelimited by Space.

Skip all but the desired column.


Gord Dibben Microsoft Excel MVP

On Mon, 26 Sep 2011 06:59:27 -0700 (PDT), sylink
wrote:

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

Extraction
 

Hi
If all your data start with all the same lenght then try this in column B and
copy down.
=MID(A1,28,4) you may need to change the cell reference.
HTH
Cimjet
"sylink" wrote in message
...
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

Extraction
 

sylink brought next idea :
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

If you need the data to the right of NTB/BND...

=MID(A1,28,LEN(A1)-28)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc