Hi

I have a column that contains cells with tag numbers and description, I need
to extract the tag number and place this two cells to the right, ie I need to
copy the left most string within a cell.

Thanks
Alec

If the tag number is a constant number of characters.

=LEFT(cell,"number of characters you want to show")

Regards,

Rikki

"Alectrical" wrote:

> Hi
>
> I have a column that contains cells with tag numbers and description, I need
> to extract the tag number and place this two cells to the right, ie I need to
> copy the left most string within a cell.
>
> Thanks
> Alec

Thanks for your prompt reply, unfortunately, the number of characters can
vary between 2 and 6.

"Chiccada" wrote:

> If the tag number is a constant number of characters.
>
> =LEFT(cell,"number of characters you want to show")
>
> Regards,
>
> Rikki
>
> "Alectrical" wrote:
>
> > Hi
> >
> > I have a column that contains cells with tag numbers and description, I need
> > to extract the tag number and place this two cells to the right, ie I need to
> > copy the left most string within a cell.
> >
> > Thanks
> > Alec

Try this:

=LEFT(A1,FIND(" ",A1)-1)

Finds where the first space is and then extracts the characters to the
left of that.

Hope this helps.

Pete

On Jul 3, 11:23*am, Alectrical <Alectri...@discussions.microsoft.com>
wrote:
> Thanks for your prompt reply, unfortunately, the number of characters can
> vary between 2 and 6.
>
>
>
> "Chiccada" wrote:
> > If the tag number is a constant number of characters.
>
> > =LEFT(cell,"number of characters you want to show")
>
> > Regards,
>
> > Rikki
>
> > "Alectrical" wrote:
>
> > > Hi
>
> > > I have a column that contains cells with tag numbers and description,I need
> > > to extract the tag number and place this two cells to the right, ie Ineed to
> > > copy the left most string within a cell.
>
> > > Thanks
> > > Alec- Hide quoted text -
>
> - Show quoted text -

On Thu, 3 Jul 2008 03:00:02 -0700, Alectrical
<(E-Mail Removed)> wrote:

>Hi
>
>I have a column that contains cells with tag numbers and description, I need
>to extract the tag number and place this two cells to the right, ie I need to
>copy the left most string within a cell.
>
>Thanks
>Alec

Since you give no examples of your data, is it safe to assume that the first
<space> in your string separates the tag number from the description?

If so, you can use a formula, in the 2nd cell to the right, similar to:

=left(cell_ref,find(" ",cell_ref)-1)

IF not, you will need to provide more information.
--ron

Thanks Pete



"Pete_UK" wrote:

> Try this:
>
> =LEFT(A1,FIND(" ",A1)-1)
>
> Finds where the first space is and then extracts the characters to the
> left of that.
>
> Hope this helps.
>
> Pete
>
> On Jul 3, 11:23 am, Alectrical <Alectri...@discussions.microsoft.com>
> wrote:
> > Thanks for your prompt reply, unfortunately, the number of characters can
> > vary between 2 and 6.
> >
> >
> >
> > "Chiccada" wrote:
> > > If the tag number is a constant number of characters.
> >
> > > =LEFT(cell,"number of characters you want to show")
> >
> > > Regards,
> >
> > > Rikki
> >
> > > "Alectrical" wrote:
> >
> > > > Hi
> >
> > > > I have a column that contains cells with tag numbers and description, I need
> > > > to extract the tag number and place this two cells to the right, ie I need to
> > > > copy the left most string within a cell.
> >
> > > > Thanks
> > > > Alec- Hide quoted text -
> >
> > - Show quoted text -
>
>

Thanks Ron

"Ron Rosenfeld" wrote:

> On Thu, 3 Jul 2008 03:00:02 -0700, Alectrical
> <(E-Mail Removed)> wrote:
>
> >Hi
> >
> >I have a column that contains cells with tag numbers and description, I need
> >to extract the tag number and place this two cells to the right, ie I need to
> >copy the left most string within a cell.
> >
> >Thanks
> >Alec
>
> Since you give no examples of your data, is it safe to assume that the first
> <space> in your string separates the tag number from the description?
>
> If so, you can use a formula, in the 2nd cell to the right, similar to:
>
> =left(cell_ref,find(" ",cell_ref)-1)
>
> IF not, you will need to provide more information.
> --ron
>

You're welcome.

Pete

On Jul 3, 3:52*pm, Alectrical <Alectri...@discussions.microsoft.com>
wrote:
> Thanks Pete
>