Prev: Sort Worksheets
Next: encryption
From: Jacob Skaria on 19 Mar 2010 02:35
Gary

Split() by default takes space as delimiter and hence

Split(range("A1"))(1)

is enough

--
Jacob


"Gary Keramidas" wrote:

> and if a code solution is preferable:
>
> split(range("A1")," ")(1) ' BASSAM
> split(range("A1")," ")(2) ' INTERNATIONAL
>
>
>
> --
>
>
> Gary Keramidas
> Excel 2003
>
>
> "Narnimar" <Narnimar(a)discussions.microsoft.com> wrote in message
> news:1FF9643F-3492-4744-BE86-2969BBFBD75F(a)microsoft.com...
> > How can I extract the second word in a cell into a cell? I don't
> > want the first word or any other words to go with it into the new cell
> > from
> > company name.
> > e. g. from AL BASSAM INTERNATIONAL FACTORIES extract BASSAM only.
> > Also I would like to know to extract only third word in case I may need
> > for
> > future alternatively.
> >
>
> .
>
From: Gary Keramidas on 19 Mar 2010 02:37
just for the heck of it, here's a solution just using search.

=MID(A1,SEARCH(" ",A1,1)+1,SEARCH(" ",A1,SEARCH(" ",A1,1)+1)-SEARCH("
",A1,1)-1)

--


Gary Keramidas
Excel 2003


"Narnimar" <Narnimar(a)discussions.microsoft.com> wrote in message
news:1FF9643F-3492-4744-BE86-2969BBFBD75F(a)microsoft.com...
> How can I extract the second word in a cell into a cell? I don't
> want the first word or any other words to go with it into the new cell
> from
> company name.
> e. g. from AL BASSAM INTERNATIONAL FACTORIES extract BASSAM only.
> Also I would like to know to extract only third word in case I may need
> for
> future alternatively.
>

First  |  Prev  | 
Pages: 1 2
Prev: Sort Worksheets
Next: encryption